Query question

[Sully38]

I have two tables( Table A & B) and need to display all the records in [Table A] where [field 1.table A] = [field 1. Table B] or [field 2. Table B] or [field 3. Table B] . I keep getting errors trying to use an OR within my inner join, is there a catch to hitting on multiple fields?
Any help is appreciated!

 

[dk]

Hi,

How about this?

SELECT TableA.Field1 FROM TableA, TableB 
WHERE (((TableA.Field1)=[TableB]![Field1]
 Or (TableA.Field1)=[TableB]![Field2]
 Or (TableA.Field1)=[TableB]![Field3]));

HTH

 

[Sully38]

I owe you .. good suggestion, EXACTLY WHAT I WAS LOOKING FOR!! It's amazing how proper syntax corrects all...