Where two things DONT match

[stephenaa5]

Hi, all. I have two tables, one has a list of sites with numerous data points in it. The second has a list of one of those data points' possibilities. Example:

Table 1= Name, Rank,Assignment
Table 2= Assignment, value

I need to create a query that results in the data from table 1, for which Assignment does not match.

So, if table 1 looks like:

David private Quarterback
Mark corporal Runningback
Angela General cheerleader

And Table 2 looks like:
Quarterback 1
Runningback 37

Then the return would be:

Angela General Cheerleader

Because cheerleader isn't an option in table 2.



Thanks in advance!

Stephen.

[pbaldy]

Have you played with the unmatched query wizard?

[stephenaa5]

Now I have! Thank you! Never even noticed that.

Stephen.

[pbaldy]

No problem! There are about a billion things hidden in the crevices of the program.