Options for joined tables enable the FROM clause of the seed statement to specify that multiple tables be joined in explicit ways, described as follows.
- query_name
- Named query referred to in the FROM clause.
- join_table_name
- Name of a joined table.
- INNER JOIN
- Join in which qualifying rows from one table are combined with qualifying rows from another table according to a join condition.
- LEFT OUTER
- Outer join with the table that was listed first in the FROM clause.
- RIGHT OUTER
- Outer join with the table that was listed second in the FROM clause.
- JOIN
- Introduction to the name of the second table to participate in the join.
- joined_table
- Name of the joined table.
- ON search_condition
- One or more conditional expressions that must be satisfied by the result rows.