Only include rows where the joined fields from both tables are equal

[newkid via AccessMonster.com]

Is it possible to make a join on a query, and not include the rows where the
joined feilds are equal?

 

[Douglas J. Steele]

You can go into the SQL statement and change

ON Table1.Field1 = Table2.Field1

to

ON Table1.Field1 <> Table2.Field1

However, are you sure you want that? It has the potential of giving you
thousands of rows...

 

[Krzysztof Naworyta]

newkid via AccessMonster.com <u51019@uwe>

| Is it possible to make a join on a query, and not include the rows
| where the joined feilds are equal?

select t1.*, t2.*
from
table1 t1
left join
table2 t2
on
t1.fieldA = t2.fieldA
where
t2.fieldA is Null

UNION ALL

select t1.*, t2.*
from
table1 t1
right join
table2 t2
on
t1.fieldA = t2.fieldA
where
t1.fieldA is Null