Reverse Join?

[Job]

I want to display all the values in a table, where a fields values do not
match the values from a different table.

If I were to want the matches, I would simply join Table1.Field1 to
Table2.Field1. Howerver, I want something like Select * from Table1, Table2
Where Table1.Field1 <> Table2.Field1

Cheers,

Job

 

[Rick B]

Create an UNMATCHED query. The wizard will walk you through it.

 

[Jeff Boyce]

Start up the query wizard and select the "unmatched" query. Let the wizard
do the work first, then you can look at the SQL generated to see the syntax.

Regards

Jeff Boyce
<Access MVP>

 

[Job]

Perfect...Thanks All..