If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Query to find outliers
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. |
Thread Tools | |
Display Modes | |
|
|