Hi All,
I want to create a query which compares common field of two tables & should provide the list of records which are not common from Table 1.
SELECT [Table1].Material
FROM Table1, Table2 WHERE ((([Table1].Material)<>[Table2].[Material]));
Both table have more than 200000 records.
But when I run the query I get more than 500000 records ... I don't know from where.
I just want to get the records from Table1 which are not common in Table2.
Please guide to get this done.
Regards
Sudhir