3 tables, table A 1 field, tableB 2 fields, tableC 1 fields. linking?

[waynr89]

I am having trouble running queries with 3 tables. Table A connects to table B by field 1, table B and C have fields 1 and 30 in common, respectively. So in the relationships I link A to B by field 1 in each. and the B to see by their corresponding fields. The query returns no results.

I need these all connected so that I can run queries with all tables.

Thanks

 

[Remou]

Please post the SQL of the query.

 

[waynr89]

SELECT Build.Field1, Parcel.Field1, Parcel.Field30, Taxname.Field1
FROM (Parcel INNER JOIN Build ON Parcel.Field1=Build.Field 1) INNER JOIN Taxname ON (Build.ID= Taxname.ID) AND (Parcel.Field30=Taxname.Field1);

 

[PHV]

ON (Build.ID=Taxname.ID) AND (Parcel.Field30=Taxname.Field1)
I wonder access admits this join expression ...