Skip to Content
0
Former Member
Nov 29, 2006 at 01:48 PM

table joins

30 Views

hi,

Kindly tell me how to wrute this query ...

I have a field 'f1' in a table T1 and a similar field 'f2' in table T2. I need to find the list of the fields f1 from table T1 which are not present in T2.

I have written a query .... please revert back with modifications needed ...

select a~f1

into var

from T1 as a

WHERE not exists ( select b~f2 from tT2 as b

where af1 = bf2

and b~firma eq 'SW01'

and b~object eq 'ACCOUNT' ).

write : / var.

endselect.

thx..

paul