help with query between to tables...

V

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.
 
D

dlw

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top