Export (0) Print
Expand All
Expand Minimize

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

Community Additions

ADD
Show:
© 2015 Microsoft