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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with a "like" query between two fields from two different tables... 2
Total appointments per agent 2
Complex for me but may be a very simple query for you experts. 2
Querie based on two sets of criteria 2
count within a given range 1
Showing two 'counts' on the same row 4
Sort order by customer name not working in query 5
Duplication of query 1

Back
Top