For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
I wrote like below
select r.returnid, r.orderid from returns left join orders on r.orderid = o.orderid where orderid is null
