Joined Tables
Options for joined tables enable the FROM clause of the seed statement to specify that multiple tables be joined in explicit ways, as described below.
|
Syntax Element … |
Specifies … |
|
joined_table |
the name of a joined table. |
|
INNER |
a join in which qualifying rows from one table are combined with qualifying rows from another table according to some join condition. Inner join is the default join type. |
|
LEFT OUTER |
an outer join with the table that was listed first in the FROM clause. In a LEFT OUTER JOIN, the rows from the left table that are not returned in the result of the inner join of the two tables are returned in the outer join result and extended with nulls. |
|
RIGHT OUTER |
an outer join with the table that was listed second in the FROM clause. In a RIGHT OUTER JOIN, the rows from the right table that are not returned in the result of the inner join of the two tables are returned in the outer join result and extended with nulls. |
|
FULL OUTER |
that rows be returned from both tables. In a FULL OUTER JOIN, rows from both tables that have not been returned in the result of the inner join will be returned in the outer join result and extended with nulls. |
|
JOIN |
an introduction to the name of the second table to participate in the join. |
|
ON search_condition |
one or more conditional expressions that must be satisfied by the result rows. An ON condition clause is required if the FROM clause specifies an outer join. If you specify the value for a row-level security constraint in a search condition, it must be expressed in its encoded form. |
|
CROSS JOIN |
an unconstrained or Cartesian join; it returns all rows from all tables specified in the FROM clause. |