INNER JOIN Operation (Microsoft Access SQL) [Access 2007 Developer Reference]

Combines records from two tables whenever there are matching values in a common field. ... You can also link several ON clauses in a JOIN statement, using the following syntax: SELECT fields FROM table1 INNER JOIN table2 ON table1.field1 compopr table2.fi

msdn.microsoft.com