Distinct Query

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

Guest

I have a make-table query that I run daily and I would like to query those
tables and return only the records that are different. I've done this before
but I've gone completely blank - can anyone point me in the right direction
please?
Thanks in advance
 
If you meen that you want all the records that apear in table1 but not in
table 2 then use this query

SELECT Main1.*
FROM Main2 RIGHT JOIN Main1 ON Main2.UserId = Main1.UserId
WHERE Main2.UserId Is Null

use a right join and then filtr with null
 
SusieQ said:
I have a make-table query that I run daily and I would like to query those
tables and return only the records that are different.
Click to expand...

Use the query wizard to create a Find Unmatched query, then
switch it to an Append query.
 
Back
Top