Comparing two tables.

[elmister]

Hi, I need to create a query that will compare both tables and just send out the records that dont match to a report.



Table1 asset#,Serial#
Table2 asset#,Serial#


query that checks that in Table1 the asset OR the Serial match the what is in Table2. and if it does not find a match to send it to a report.

please help. i have tried everything.


thank you for your time.

[ajetrumpet]

try unionizing it with 2 left join queries.

select * from table1 left join table2 on 

(table1.asset = table2.asset)

UNION

select * from table1 left join table2 on 

(table1.serial = table2.serial)

I wonder if that would work...it does in theory, I know that. But if Access likes it, that's the question!

UNION queries require the same amount of fields from both statements.