About Table and Database Joins

If you are using more than one table or database in a BarTender document, the tables or databases must be joined.

A database join (or simply, a join) tells BarTender how data in multiple tables or databases is related. Typically, this means identifying a field that exists in two different tables whether the two tables exist in a single database or in separate databases. While the field names themselves might be different, the data of the fields that is common to both tables is called relational data.

Consider the following two tables. The first table lists employee first names and their department IDs. The second table lists department names and the ID associated with each department name. The relational data is the DepartmentID values that are shared by both tables.

FirstName	DepartmentID
Jack	31
Rennie	33
Mike	34
Susan	NULL

DepartmentID	DepartmentName
31	Sales
33	Engineering
34	Clerical
35	Marketing

Joining tables and databases is accomplished in the Database Setup dialog, where you can specify on what field they are joined. For more information, refer to Database Join Types.

Related Topics