Share via


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.

  • 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

Add Table or View Dialog Box | SELECT - SQL Command | SET ANSI Command | Query Destination Dialog Box | Defining Multiple Join Conditions | Query Designer