Example: Simple INSERT … SELECT Using Set Operators - Teradata Database

Example: Simple INSERT … SELECT Using Set Operators - Teradata Database - Teradata Vantage NewSQL Engine

SQL Data Manipulation Language

Product

Teradata Database

Teradata Vantage NewSQL Engine

Release Number

16.20

Published

March 2019

Language

English (United States)

Last Update

2019-05-03

dita:mapPath

fbo1512081269404.ditamap

dita:ditavalPath

TD_DBS_16_20_Update1.ditaval

dita:id

B035-1146

lifecycle

Product Category

Teradata Vantage™

INSERT table1 (x1,y1)
SELECT *
FROM table_2
UNION
SELECT x3,y3
FROM table_3;