Example: INSERT … SELECT from a View that Uses Set Operators - Advanced SQL Engine

Example: INSERT … SELECT from a View that Uses Set Operators - Advanced SQL Engine - Teradata Database

SQL Data Manipulation Language

Product

Advanced SQL Engine

Teradata Database

Release Number

17.05

Published

January 2021

Language

English (United States)

Last Update

2021-01-22

dita:mapPath

vnq1596660420420.ditamap

dita:ditavalPath

hoy1596145193032.ditaval

dita:id

B035-1146

lifecycle

Product Category

Teradata Vantage™

REPLACE VIEW v AS
SELECT *
FROM table_1
UNION
SELECT *
FROM table_2;
INSERT table_3(x3,y3)
SELECT *
FROM v;