Joins of tables within the same database are made on either the Create join tables page of the Add Database Connection Wizard or the Join tab of the Database Connection Setup dialog.
Multi-Database Joins Tab |
The Multi-Database Joins tab, located in the Database Connection Setup dialog, allows you to join multiple databases, rather than multiple tables within a database. To make the tab visible, select All Databases at the top of the tree view in the dialog. A join tells
Left Table. Specifies the first table you would like to join.
Left Field. Specifies the field from the Left Table that you would like to join.
Operator. Specifies the operator that defines the relationship between Left Field and the Right Field.
Right Table. Specifies the table that is related to the Left Table.
Right Field. Specifies the field from the Right Table that is related to the Left Field.
Join Type. Defines the type of join. All multi-database joins within
|
|
Joins of tables within the same database are made on either the Create join tables page of the Add Database Connection Wizard or the Join tab of the Database Connection Setup dialog. |
Related Topics