Compare table 1 to table 2 and send results to query 1

[JOD59]

I have 2 tables that have asset numbers. I want to compare the first table to the secound and get a list of the assets that do not match the second. Does anyone know how I would do this???

 

[traingamer]

Select tbl1.*, tbl2.[asset] from tbl1 
left join tbl2 ON tbl1.[asset] = tbl2.[asset]
where (tbl2.[asset]) is null

OR just create a query with the Find Unmatched Query Wizard

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill

 

[JOD59]

Thanks that did the trick