Join choice Displays the Join Clause dialog box.

Use this dialog box to join two selected tables. A join clause lets you get data from multiple tables via a single SQL SELECT statement.

If there is a primary/foreign key relationship between the tables in a SELECT statement, you can have DB/Assist create the join clause automatically. See help for the SELECT/FROM Clause dialog box for information.