Do an exception join on the detail file
This will list all the detail records that do NOT have an order number in the header file
Select a.* from ORDDETAIL a exception join ORDHEADER b on
a. ODOHNO = b. OHOHNO
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.