-
, / , - , , , .
SELECT FROM 1, 2,... n;
, T1, T2,..., n. , FROM, , , - .
. , :
SELECT FROM Mytab T1, Mytab T2;
, :
SELECT FROM Mytab, Mytab;
.
, , (*), .
SQL CROSS JOIN ( ):
SELECT FROM Mytab T1 CROSS JOIN Mytab T2;
:
. Microsoft Access (SELECT FROM T1, T2,... Tn), . , (select FROM Mytab T1, Mytab T2) Access AS . CROSS JOIN Access .
. , WHERE.
è :
, (_, _), , .
. . . , , . . . (. ), :
SELECT 1._, 2._
FROM 1, 2
WHERE T1._ = 2._;
. . :
1._,
1.__,
2._
|
|
2._.
, 1._ = 2._. , . , : 1._ 2._.
(UNION)
. , , , , . union ():
1 UNION 2;
. , UNION ALL.
, . , , :