Join Condition Dialog Box
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.
For more information about join conditions, see Join Conditions for Tables, Queries, and Views.
- 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.
Type of Join
- 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 that includes the Right Field List records and the matching Left Field List records for the fields selected.
- Full Join
Creates a join that 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.
See Also
Reference
Add Table or View Dialog Box
SELECT - SQL Command
SET ANSI Command
Query Destination Dialog Box