SELECT Statement and Joins - Analytics Database - Teradata Vantage

Database Introduction

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-09-27
dita:mapPath
gtm1628096154303.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
dsm1472253642401
lifecycle
latest
Product Category
Teradata Vantageā„¢

A SELECT statement can reference data in two or more tables and the relational join combines the data from the referenced tables.

In this way, the SELECT statement defines a join of specified tables to retrieve data more efficiently than without defining a join of tables.

There are two kinds of joins:

Join Description
Inner Selects data from two or more tables that meet specific join conditions. Join condition (common relationship among the tables to join) can be on ON clause or WHERE clause.
Outer Extension of the inner join that includes the following:
  • Rows that qualify for a simple inner join.
  • Specified set of rows that do not match the join conditions expressed by the query.