Not Equal to

[jiayue]

I am joning these 2 tables with [Product Code] to [Product No] in a query. Question is : how can I retrieve those [Product Code] which is not equeal to [Product No]?

I believe I need to use a SQL to relate it but how is it? Is it Not equal To or <>, I had tried both but fails....

Please teach.

Thnaks

jiayue

 

[gol4]

do a left join then look for nulls
SELECT Table1.[Product Code], table2.[Product no]
FROM Table1 LEFT JOIN table2 ON Table1.[Product Code] = table2.[Product NO]WHERE (((table2.[Product Code]) Is Null));