7
, , , .
:
1. ( , CROSS JOIN).
2. (INNER JOIN);
3. (OUTER JOIN);
SELECT FROM , , , WHERE, .
1.
SELECT _, _
FROM ,
, .
, CROSS JOIN:
SELECT . _, . _
FROM CROSS JOIN
, , , .
, , , . WHERE.
, SQL , .
.
( ) - , :
2.
SELECT . , .
FROM ,
WHERE .ID_ = .
, , , .
(INNER) . , , .
, ANSI:
SELECT < >
FROM < > < JOIN > < >
ON < >
, JOIN:
3.
SELECT . , .
FROM INNER JOIN
ON .ID_ = . ;
I NNER , .. JOIN .
|
|
|
2 T-SQL. , . .
3 , ANSI.
!
ANSI.
, Microsoft , T-SQL .
. - .
4.
SELECT *
FROM AS INNER JOIN AS P
ON . ID_ = P. ;
ON . , AND OR.
1. *
JOIN * . , , .
2.
. ID_ , - .
