Query to find outliers

J

John

I have two tables, one table listing names of people who did not receive a
gift card and a second table of people who were taxed for the gift cards.
Both tables use the name field ( I did not set up the tables but this field
is first and last name) in common. I need to find out if there are people on
the tax list who did not receive a gift card. So if a name is on the tax list
it should not be on the did not receive list. Therefore, they were taxed for
the card but never received it.
 

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

Top