15.10 - joined_table - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

Name of a joined user base table or view.

You can create views that reference global temporary tables and volatile tables.

A view can reference a global temporary trace table but such a view is not updatable. See CREATE GLOBAL TEMPORARY TRACE TABLE.

You cannot create a view on a queue table. See CREATE TABLE (Queue Table Form).

INNER
A join in which qualifying rows from one table are combined with qualifying rows from another table according to a specified join condition.
INNER is the form specified by the ANSI SQL-2011 standard. Teradata also supports an extension that allows you to separate join relations using COMMA characters.
Inner join is the default join type for view definitions.
OUTER
A join in which qualifying rows from one table or view that do not have matches in the other table or view, are included in the join result. The rows from the outer table or view are extended with nulls.
See SQL Data Manipulation Language, B035-1146 for more information about outer joins.
LEFT OUTER
An outer join on the table or view that was listed first in the FROM clause.
In a LEFT OUTER JOIN, the rows from the left table or view that are not returned in the result of the inner join of the two tables/views are returned in the outer join result and extended with nulls.
RIGHT OUTER
An outer join on the table or view that was listed second in the FROM clause.
In a RIGHT OUTER JOIN, the rows from the right table or view that are not returned in the result of the inner join of the two tables/views are returned in the outer join result and extended with nulls.
FULL OUTER
A join that returns rows, including non-qualifying rows, from both tables or views.
In a FULL OUTER JOIN, rows from both tables that have not been returned in the result of the inner join are returned in the outer join result, and extended with nulls.