Join Condition Dialog Box

JavaScript Editor js editor     Web development 



Main Page

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



JavaScript Editor js editor     Web development