topic Re: transform 2 select to Join in Application Development and Automation Discussions

transform 2 select to Join

former_member810309 — Thu, 18 Aug 2022 10:19:17 GMT

hi all

I'm trying to transform these 2 selects query into a signle query with inner join or join ! (don't know what i should use).

thanks.

SELECT SINGLE reference 
  FROM e070a
  INTO lv_reference
  WHERE trkorr EQ ls_result-trkorr
  AND attribute EQ 'lc_scp'.
 IF sy-subrc EQ 0.
  SELECT SINGLE externalid
   FROM ctsproject
   INTO ls_result-externalid
   WHERE trkorr EQ lv_reference.
  IF sy-subrc EQ 0. ENDIF.
ENDIF.

Re: transform 2 select to Join

venkateswaran_k — Thu, 18 Aug 2022 10:30:32 GMT

  SELECT SINGLE externalid
   FROM ctsproject as a INNER JOIN e070a as b on a~trkorr EQ b~reference
   INTO ls_result-externalid
   WHERE B~attribute EQ 'lc_scp' AND
         B~TRKORR EQ LS_RESULT-TRKORR.

Regards,

Venkat

Re: transform 2 select to Join

Sandra_Rossi — Thu, 18 Aug 2022 11:35:18 GMT

If your question is "what is the difference between inner join and join", the answer is none. JOIN is the short form of INNER JOIN, but I think it's best to use INNER JOIN to not confuse with other forms of joins (left (outer) join, right join, cross join).

Re: transform 2 select to Join

former_member810309 — Thu, 18 Aug 2022 11:52:57 GMT

THANKS A LOT MR VENKAT

Re: transform 2 select to Join

former_member810309 — Thu, 18 Aug 2022 11:55:50 GMT

sandra.rossi it wasn't my question but thanks for the explanation.