17.10 - explicit_join - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1144-171K
Language
English (United States)

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.
Inner join is the default join type.
LEFT OUTER
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
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.
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.
A value you specify for a row-level security constraint in a search condition must be in encoded form.
An ON condition clause is required if the FROM clause specifies an outer join.