help with query between to tables...

[VMI]

I have two tables and I want to create a query that checks if table1.field1
= table2.field1 AND (table1.field2 <> table2.field2 OR table1.field3 <>
table2.field3). How would it look like?

Thanks.

 

[Guest]

use the iif ( ) operator, and use [table1]![field1] [table2]![field1]
instead of table1.field1 etc

 

[Yifei Jiang]

Hi,

it could be

select count(tb.field1) from table1, table2, table3
where table1.field1 = table2.field1 AND (table1.field2 <> table2.field2 OR
table1.field3 <>
table2.field3).

My 2c

Yifei