Dear Gurus,
select tdsfl003.*
from tdsfl003
where tdsfl003.orno not in (select tdrpl100.orno from tdrpl100)

can u explain this code for me especially after not in .

Basically it finds all the orders in tdsfl003 that do not exist in tdrpl100.