INTERSECT (), , :
1 INTERSECT 2;
. , INTERSECT ALL.
UNION, INTERSECT CORRESPONDING. , .
, . , , :
SELECT * FROM 1
INTERSECT
SELECT * FROM 2;
, 1 2 . - , ID_ _ , :
SELECT * FROM 1
INTERSECT CORRESPONDING(ID_, _)
SELECT * FROM 2;
INTERSECT CORRESPONDING, , .
(EXCEPT)
, , EXCEPT ( ):
1 C 2;
, . , UNION INTERSECT, EXCEPT CORRESPONDING.
, . , , :
SELECT * FROM
EXCEPT CORRESPONDING (, )
SELECT * FROM ;
, . , , .
, . JOIN ().
, , JOIN. , , . SQL- CROSS JOIN. , . .
:
, JOIN, ( ). "" UNION - , ( ) , . JOIN , . , JOIN, ( ).