Specifies a join condition between tables. This dialog box appears when you add more than one table in your query or view, and those tables do not have a join condition already specified.
Right Field List
Shows the fields from the table you have added. Select a field from the list by which to join the tables.
Left Field List
Shows the fields from all of the tables previously added into the Query Designer. Select a field from the list by which to join the tables.
Inner Join
Creates a join that will list only the records from the Left Field List that match the records from the Right Field List for the fields selected.
Left Join
Creates a join that includes the Left Field List records and the matching Right Field List records for the fields selected.
Right Join
Creates a join which includes the Right Field List records and the matching Left Field List records for the fields selected.
Full Join
Creates a join which includes all the records from both list boxes for the fields selected in the list boxes.
Description
Specifies how the fields of each table will relate to each other when you select the different join options.