5.2.2 Outer Join

When you join two tables, the default join type created is an equi-join. This join type preserves only the rows of the two tables that have matching values on the join columns.

Sometimes, in addition to preserving the matching rows, you may also want to preserve all the rows of one or both base tables. A join which preserves all rows of one or both base tables is called an outer join.

See Also

Inner Join, for information about the default equi-join.

Changing the Join Type, to change equi-join to outer join or type of outer join.

<< Creating an Inner Join with the 'Join Table' Button © 1996-2013 InetSoft Technology Corporation (v11.4) 5.2.3 Cross Join >>