例 - Teradata Database - Teradata Vantage NewSQL Engine - 集合演算子、SUBQUERYの例。

Teradata Vantage™ SQLデータ操作言語

Product: Teradata Database; Teradata Vantage NewSQL Engine
Release Number: 16.20
Published: 2019年3月
Language: 日本語
Last Update: 2019-10-29
dita:mapPath: ja-JP/fbo1512081269404.ditamap
dita:ditavalPath: ja-JP/fbo1512081269404.ditaval
dita:id: B035-1146
Product Category: Software; Teradata Vantage

SELECT x1 
FROM table_1 
WHERE (x1,y1) IN 
(SELECT * FROM table_2 
UNION 
SELECT * FROM table_3);