Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. waynr89

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

    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);
  2. waynr89

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

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

Part and Inventory Search

Back
Top