Creating a join

In a SQL query, a join performs a relation on one or more columns stored in two separate tables and combines them into a single table. The table created by the join provides data that answers your query and which is then displayed on a Query Builder report.

Rather than creating joins manually, you can allow Query Builder to automatically create joins based on column names and data types, or primary key and foreign key relationships. For information on the different options to automatically create joins, see Query Builder Options dialog box.

To create a join

1. Access the Query Builder Editor.

2. Add tables to your Query Builder report. The tables are added to the Tables and Joins pane (the top pane on the right).

3. Select a column in a table and drag it onto another column in a separate table.

The Query Builder Editor represents the join by drawing a line connecting the two columns.

Related Topics

• Join Editor

• Modifying a join

• Removing a join

• Query Builder Options dialog box: automatically create joins