Help with a Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two columns/fields of data. Column 1 has 13,000 entries, Column 2 has
7,000. (Column 2 is a subset of Column 1) I want to find out which items in
Column1 DO NOT appear in Column 2. I can get the overlap, but not the delta.
Any help would be appreciated.
 
In the same table or different tables? Same table you need to reference your
table as two separate instances in the query. Something like:

SELECT T1.Column1
FROM YourTable as T1 LEFT JOIN YourTable as T2
 
Right now I have it in 2 tables, but can put them in one if need be. I will
try what you suggest.
 
Matt said:
I have two columns/fields of data. Column 1 has 13,000 entries, Column 2
has
7,000. (Column 2 is a subset of Column 1) I want to find out which items
in
Column1 DO NOT appear in Column 2. I can get the overlap, but not the
delta.
Any help would be appreciated.
Click to expand...

Have you tried using the query wizard to create an Unmatched Query? That
will tell you which records in one table don't appear in the other.

Tom Lake
 
Thanks Tom. Your response made me realize that the Add-in is not installed,
hence the lack of transparency in finding the solution.
 
No! Don't combine them. Just do an unmatched query with the query wizard.

SELECT YourTable.Column1
FROM YourTable LEFT JOIN SomeOtherTable
 
Back
Top