INTERSECT Syntax | SQL Statements | Teradata Vantage - INTERSECT Operator Syntax - Analytics Database - Teradata Vantage

query_expression_1 INTERSECT [ ALL ] query_expression_2

Syntax Elements

query_expression_1

A complete SELECT statement to be INTERSECTed with query_expression_2.

For details, see query_factor Syntax.

ALL

Allows duplicate rows to be returned.

query_expression_2

A complete SELECT statement to be INTERSECTed with query_expression_1.