Example: INSERT ... SELECT from Derived Table with Set Operators - Advanced SQL Engine

Example: INSERT ... SELECT from Derived Table with Set Operators - Advanced SQL Engine - Teradata Database

SQL Data Manipulation Language

Product

Advanced SQL Engine

Teradata Database

Release Number

17.10

Published

July 2021

Language

English (United States)

Last Update

2021-07-27

dita:mapPath

vjt1596846980081.ditamap

dita:ditavalPath

vjt1596846980081.ditaval

dita:id

B035-1146

lifecycle

Product Category

Teradata Vantage™

INSERT table_1
SELECT *
FROM
(SELECT x2,y2
FROM table_2
UNION
SELECT *
FROM table_3 DerivedTable
);