exception report?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am tryimg to get a query to return the names that do not exist in two
tables. I have table one that is a customer table with info such as name, id
number etc.. I have a second table that has orders by customers. What I'd
like to get are the customer names that appear in the order table but are not
in the customer table. Hope this makes sense. Any help would be appreciated.

Thank you
 
sacredarms said:
I am tryimg to get a query to return the names that do not exist in two
tables. I have table one that is a customer table with info such as name, id
number etc.. I have a second table that has orders by customers. What I'd
like to get are the customer names that appear in the order table but are not
in the customer table. Hope this makes sense. Any help would be appreciated.

Thank you
Click to expand...

The unmatched query wizard will do this for you.
 
Back
Top