Joining Tables
In order to join tables, you have to create a link between an object in each of the tables.
To join tables:
1. Open at least two tables in the Query Building Area.
2. Select the field that you want to link in the first table and drag it to the corresponding field of the other object.
A line that connects the two fields will appear:
The default join type is INNER JOIN -only records that match in both tables will be included in the resulting dataset.
3. To Define other types of joins, right click the link and select Edit.... You can also double-click the link.
The Link Properties dialog box appears:
You can define join type and other link properties in the Link Properties dialog box.
4. To remove a link between objects, right click the link line and select Remove.