Need results for 2 unmatching fields!

[bowes884]

Ok. I have a list of numbers in 2 fields. What do I do for the criteria to show the numbers that are not the same for each field. Ex:

693 703<----
756 756
733 737<----
733 781<----
664 664

Both numbers are from 2 separate tables. How do I get teh query to only show the numbers that dont match?

 

[RV]

Create two subqueries:

SELECT *
FROM Table1
WHERE column1 NOT IN
(
SELECT column2
FROM Table2
)

SELECT *
FROM Table2
WHERE column2 NOT IN
(
SELECT column2
FROM Table1
)

You can use an UNION to combine the results of both queries.

RV)