FROM Clause Syntax | SQL SELECT Statements | Teradata Vantage - FROM Clause Syntax - Advanced SQL Engine - Teradata Database

SQL Data Manipulation Language

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
September 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
qtb1554762060450.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1146
lifecycle
previous
Product Category
Teradata Vantage™
FROM source_spec [,...]

Syntax Elements

source_spec
{ table_name [ [AS] correlation_name ] |
  join |
  derived_table_spec |
  table_function |
  table_operator
}
table_name
Name of a base table, queue table, global temporary table, volatile table, derived table, or view. If the database is omitted, the system infers it from context.
correlation_name
Optional alias for the table that is referenced by table_name.
You must specify a correlation_name for a self-join.
ANSI SQL refers to table aliases as correlation names. Correlation names are also referred to as range variables.
join
joined_table {
  [ INNER | { LEFT | RIGHT | FULL } [ OUTER ] ]
    JOIN joined_table ON search_condition |

  CROSS JOIN single_table
}
derived_table_spec
See Derived Tables.
table_function
See TABLE Option.
table_operator
See Table Operator.
joined_table
Name of a joined table, which can be either a single table name with optional alias name, or a joined table, indicating nested joins.
INNER
Join in which qualifying rows from one table are combined with qualifying rows from another table according to some join condition.
Inner join is the default join type.
OUTER
Join in which qualifying rows from one table that do not have matches in the other table, are included in the join result along with the matching rows from the inner join. The rows from the first table are extended with nulls.
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.
FULL OUTER
Rows are returned from both tables
In a FULL OUTER JOIN, rows from both tables that have not been returned in the result of the inner join will be returned in the outer join result and extended with nulls.
search_condition
One or more conditional expressions, including scalar subqueries, that must be satisfied by the result rows.
You can only specify a scalar UDF for search_condition if it is invoked within an expression and returns a value expression.
If you specify the value for a row-level security constraint in a search condition, it must be expressed in its encoded form.
An ON condition clause is required if the FROM clause specifies an outer join.
CROSS JOIN
Unconstrained, or Cartesian, join. Returns all rows from all tables specified in the FROM clause. Two joined tables can be cross joined.
single_table
Name of a single base or derived table or view on a single table to be cross joined with joined_table.