Joins page of the SQL designer
The SQL designer Joins page lets you create multi-table SQL queries (joins). See Creating joins for steps on how to create a join.
Including Unmatched Rows
These check boxes allow you to specify full, left, and right outer joins. If only the first check box is checked, a left outer join is added to the query. If only the second check box is checked, a right outer join is added to the query. If both check boxes are checked, a full outer join is added to the query. If neither box is checked (the default), an inner join is added to the query.
Note:
The SQL1 standard doesn’t include an outer join in its specifications. Some SQL servers have restrictions on outer joins and some don’t allow outer joins. Please see your server documentation for information on its support for outer joins.
Join list box
This box appears above the grid and allows you to specify a particular join. When you select a join in this box, both tables in the join appear. When a join is selected, the grid contains the field information for that particular join.
Joins grid
The Joins grid contains three columns: Field, Operator, and Field.
To have a field appear as a choice in the Fields column drop-down list boxes, select the field in the Table Pane.
The operator column allows you to specify a comparison operator for the join. You may choose from =, <, >, <=, >=, and <>.
Deleting a join
To delete a join, in the table pane, right-click on the join line between the two joined tables, and choose Delete Join from the context menu.
Deleting a row
After selecting the row to delete, right-click and choose Delete Row from the context menu.