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.

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

Other Resources

Dialog Boxes (Visual FoxPro)

Query and View Designers