How to: Perform Joins Using Access SQL [Access 2007 Developer Reference]

In a relational database system like Access, you often need to extract information from more than one table at a time. This can be accomplished by using an SQL JOIN statement, which enables you to retrieve records from tables that have defined relationshi

msdn.microsoft.com