DB join facilitates reference between tables, from one table to another. Combine rows from two or more tables, based on a common field between them. The concepts below are all based on SQL.

Fields & its description:

• Description

Enter the description of the database join operation regarding source and destination.

• From

Specify the table from which data has to be retrieved here.

• To

This is the destination table where the data from the source is acquired.

• Type

Type may be Direct if the path of data connection is between the source and destination tables only. Indirect type is selected if several tables are accessed in order to connect the source and destination table.

If your choice is Indirect then specify the path of “indirect from” and “indirect to” table.

• Join

These are table operations where Inner join will retrieve the intersection of data from the source and destination table. Left Outer join will display the common data along with the data from source table.

• Expression

This is the expression of the DB join operation.