js editor
Web development
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.