UNION
SELECT , FROM ;
, , , . , UNION DISTINCT.
UNION , :
- ;
- . , () char varchar , .
, . , , . , cast (). , , ( ):
SELECT FROM
UNION
SELECT AST(__ AS CHAR (10)) FROM ;
, , UNION CORRESPONDING ( ):
SELECT * FROM 1
UNION CORRESPONDING ()
SELECT * FROM 2;
CORRESPONDING , . , . .
è :
, , (. . ). :
SELECT _, _ FROM
UNION
SELECT 1._, 2._ FROM 1, 2
WHERE 1._=2._;
. .
, , . . .
. , , ?
WHERE:
SELECT _, _ FROM
UNION
SELECT 1. , , 2._
FROM 1, 2
WHERE T1._ = 2._
AND T1._ = '';