show records that dont match 2

[din2005]

Hi all,

I have 2 tables... (table1 and table2) i would like to compare them and show records that dont match?

could some1 show me an example or something regarding this...

many thanks

 

[Crowley16]

define doesn't match?

you could just left join all the columns in table1 to all the columns in table2 to compare all differences

--------------------
Procrastinate Now!

 

[scottian]

Create a new query;

Put both your tables in the window and join on the field you want to compare;
Right click on the joining line and choose 'Join Properties' then select 'show all records in table "A" and only those records in table "B" where the values are the same;
Now choose the fields you joined and drag into the query;
In the 'Table "B"' criteria put 'Is Null';

hey presto - you will see all records in table "A" that arent in table "B". just flip around to get the results from table "B"

"My God! It's full of stars...

 

[PHV]

Why not simply follow the unmatched query wizard ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886