Use this dialog box to build a join clause as part of a SELECT statement. A join clause lets you retrieve and manipulate data from multiple tables in a single SQL statement.
Note: If there is a primary/foreign key relationship between the tables in the SELECT statement, the relationship is displayed graphically in the dialog box.
Table |
Lists all the tables in the database. When you select a table, its columns appear in the Column list box.
|
Column |
Lists the columns in the selected table. When you select a column, a line is drawn to the operator.
|
Operator |
Lists all valid operators for the join clause.
|
Apply |
Adds the join clause to the current statement and displays it in the SQL Editor window. If the selected columns have incompatible data types, an error message appears. You can display the Database Schema dialog box to check the data type for each column.
|
Close |
Closes the dialog box. If you have not applied the clause, it does not appear in the SQL Editor window.
|
Help |
Displays help for the dialog box.
|
Apply AutoJoin |
Automatically applies a join clause based on any single-column primary/foreign key relationships between the tables. Adds the join clause to the current statement and displays it in the SQL Editor window.
|
If there is an existing primary/foreign key relationship between the tables in the SELECT statement, you can automatically apply the join clause when you build the SELECT statement. See help for the SELECT/FROM Clause dialog box for more information.
Display this dialog box by selecting SQL Statement>Join or the Join button.
