. :
(ID_, , ID_);
(ID_, , ).
ID_.
:
SELECT * FROM , ;
. , .
, , , (.ID_= .ID_).
, , . (. ).
:
SELECT .*, ., .
FROM ,
WHERE . ID_ = .ID_;
, :
SELECT 1.*, 2., 2.
FROM 1, 2
WHERE 1. ID_ = 2.ID_;
NATURAL JOIN :
è SELECT 1.*, 2., 2.
FROM T1 NATURAL JOIN 2;
:
Microsoft Access NATURAL JOIN . INNER JOIN ( ) ON (), . , INNER JOIN .
, NATURAL JOIN, .
(JOIN... ON)
. , , ON(), WHERE. , .
, :
(ID_, , 1ID_);
(ID_, , ).
, , , :
è SELECT * FROM JOIN
ON (.ID_ = .ID_)
AND (. > 50);
:
Microsoft Access INNER JOIN... ON. INNER.