, () . , . . , . SQL . .
. .
, FROM: (LEFT JOIN), (RIGHT JOIN) (INNER JOIN).
LEFT JOIN, RIGHT JOIN, INNER JOIN:
_1, _2 , ;
_1, _2 . , ;
: =, <, >, <=, >=, <>;
ON .
_1 _2, . _1 , _2.
, _2 _1.
, , .
SQL , SELECT. , , WHERE- WHERE- :
SELECT * FROM _1 WHERE _1 = (SELECT _2 FROM _1 WHERE );
() , ( ) WHERE. , , . , , . .
SQL , , , , .. , , . , . .
|
|
, , . , , . , , , :
1) ( ), ;
2) , , .
, . , :
( , , , - );
;
;
;
..
, , , .