Joins Tab

The Joins tab, located in the Database Connection Setup dialog, allows the user to specify relationships between fields in one table and fields of the same data type in another table within the same database. A join tells BarTender how data is related.

• Left Table. Specifies the first table you would like to join. Select an available table from the dropdown list.

• Left Field. Specifies the field from the Left Table that you would like to join. Select an available field from the dropdown list.

• Operator. Specifies the operator that defines the relationship between Left Field and the Right Field. Select the appropriate operator from the dropdown list.

• Right Table. Specifies the table that is related to the Left Table. Select an available table from the dropdown list.

• Right Field. Specifies the field from the Right Table that is related to the Left Field. Select an available field from the dropdown list.

• Join Type. Defines the type of join. Select from the following options:

  • Inner Join. Returns only the records where the value of the Left Field matches the value of the Right Field. This is the most commonly used join type.

  • Left Outer Join. Returns all records contained in the left table. If a matching record exists in the right table, that data is also included.

  • Right Outer Join. Returns all records contained in the right table. If a matching record exists in the left table, that data is also included.

  • Full Outer Join. Returns all records contained in both the left and right tables.

When the Database Connection Setup dialog is opened, BarTender makes a best guess about what table and field names should go into the various cells of this tab's grid. If you make changes and then decide you want to revert to BarTender's original guess, click the Generate Join Table button.

Related Topics

• Database Connection Setup Dialog
• Database Join Types

Open topic with navigation