how two join two tables on two fields

[Guest]

I need to join two tables on two seperate fields. The first table is an
inventory list. The second is a disposition list. Each table has a model
and cage field. I would like to show every record from the inventory list
and only the records on the dispo list where the model and cage fields match
the inventory. Many thanks in advance.

Greg

 

[Douglas J. Steele]

Assuming you're using the graphical query builder, select the model field in
table one, and drag it onto the model field in table two. Do the same thing
with the cage field.

In the SQL, you should see something like:

FROM Table1 INNER JOIN Table2
ON Table1.Model = Table2.Model
AND Table1.Cage = Table2.Cage