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
Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.