topic Re: Select statement for two tables in Application Development and Automation Discussions

Select statement for two tables

Former Member — Fri, 29 Jan 2016 08:55:28 GMT

Hello mates,

i would like to Join two tables like those below. I only want the values from the table LT who are not in the Table RT.

Am i right doing a Join like this?:

SELECT x

FROM LT

WHERE NOT EXISTS (SELECT y FROM RT Where ..)

and ...

Kind Regards

Emre

sabirshah1 — Fri, 29 Jan 2016 09:20:20 GMT

Hi,

You can use Joins Like this

SELECT T1~FIELD1

T1~FIELD2

T2~FIELD1

T2~FIELD2

INTO TABLE <ITAB>

FROM T1 INNER JOIN T2 ON ( T1~FIELD1 = T2~FIELD )

WHERE T1~FIELD = <SOME VALUE> .

former_member196331 — Fri, 29 Jan 2016 09:32:32 GMT

hi,

select * from Lt into it_Lt (Intenal table of LT)

select * from Rt into it_Rt (Internal table of RT)

Loop at it_LT into wa_lt (work area of Lt).

read table it_RT into Wa_RT with key field x(Right table fieldx) = wa_LT-fieldx(Left table fieldx)

if sy-subrc ne 0.

append it to the new table.

endif.

endloop.

Tomas_Buryanek — Fri, 29 Jan 2016 09:56:48 GMT

Yeah, it should work good.


SELECT x
FROM LT
WHERE NOT EXISTS (SELECT * FROM RT
                                        WHERE y = lt~x)

Former Member — Fri, 29 Jan 2016 10:06:45 GMT

It's a sub-select not a join.

Rich

Former Member — Fri, 29 Jan 2016 11:26:40 GMT

Thank you all for your replies, I have tried it with the loop over itab and the subselect.

Both work fine. I use the subselect now

Emre