I have records for 2 fields (orderno and planningjob) that are held in the same table (binding).
I have attached a spreadsheet that is the result of:
select orderno, planningjob from binding
order by orderno
As you can see, some orderno are duplicated and some have a planningjob record associated.
Some orderno have a planningjob associated for one record but then not for another. (See Orderno 17. There are 5 records for it but only 2 have a planningjob associated).
I need to be able to only show records that don't have any planningjob associated at all Binding.xls
SELECT orderno, planningjob
WHERE planningjob IS NULL
ORDER BY orerno