I need some assistance. I appear to be having a brain fart at the moment and just can't seem to get the results I'm looking for. Here's my basic dilema:
I've got 2 tables in a SQL 2000 Database, ARDoc and Shippers... Both tables have a common order number field (OrdNbr) as well as Invoices (InvcNbr in Shippers and RefNbr in ARDoc). In some cases, the invoices between the 2 tables do not match. I need to be able to get a result set for the order numbers that do not have matching Invoice numbers. Any assistance is greatly appreciated.