Joins - Teradata Database

SQL Data Manipulation Language

Product
Teradata Database
Release Number
15.10
Language
English (United States)
Last Update
2018-10-06
dita:id
B035-1146
lifecycle
previous
Product Category
Teradata® Database

Joins

A SELECT statement can reference data in one or more sets of tables and views, including a mix of tables and views. The SELECT statement can define a join of tables or views.

You can join tables and views that have row‑level security constraints, as long as the tables and views being joined have identical row‑level security constraints. Otherwise, the system returns an error.

For more information about join operations, see “Chapter 2 Join Expressions” on page 225.

For information about how the Optimizer processes joins, see SQL Request and Transaction Processing.