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