-
Click ADD RULE.
A new line is created with the object on the left side, preselected in
the first field. If there is more than one object on the left of the selected
join, you can change the selected object.
-
Select the column from the object on the first side to be used
for join.
Columns that have a matching column name and data type with the object on the
other side of the join are displayed in blue. If such a column is selected, the
matching column from the other object is selected automatically.
-
Select the operator.
-
Select the column from the object on the second side to be
used for join.
Columns that have a matching column name and data type with the object on the
other side of the join are displayed in blue. Columns that have a data type that
is incompatible with the object on the other side are displayed in gray.