Find records not in both tables?

J

Jay

HI...Let's say I have 2 tables, tblRangesA and tblRangesB, each with
just one field 'RangeName'.

I know tblRangesA contains 5,110 distinct values, and tblRangesB has 6,008.

How do I construct one query, based on both tables linked on 'RangeName,
which will return the 890 values which are in A but not in B?

Any help greatly appreciated....Regards, Jason
 
J

Jay

Never mind, I've figured it out...

SELECT DISTINCT tblRangesB.Range
FROM tblRangesB
LEFT JOIN tblRangesA ON tblRangesB.Range = tblRangesA.Range
WHERE (((tblRangesA.Range) Is Null));
 
Top