4.1. .
4.2. , , .
4.3. , ( ).
4.4. , .
4.5. , .
4.6. , .
4.7. , , .
, SQL, . MS Access (*.mdb), , .
6.1. . 3.2
6.2. ?
6.3. ? .
3. SELECT SQL. . JOIN.
SELECT Microsoft Jet SQL JOIN Access 2 .
2.1. , :
SELECT count(*)
FROM
WHERE ._ IN
(SELECT ._ FROM , WHERE ._=._ AND .="< _ >" );
. , . , . . , , . IN. count(*).
2.2. . IINNER JOIN.
SELECT count(*)
FROM
WHERE ._ IN
(SELECT ._ FROM INNER JOIN ON ( ._=._ AND .="< _ >" ));
|
|
2.3. , .
SELECT P., Count(*)
FROM AS P,
WHERE ._ IN
(SELECT ._ FROM , AS Projects WHERE ( Projects._=._ AND Projects. = P. ))
GROUP BY P.;
, _ -, .
2.4. :
SELECT P., Count(*)
FROM AS P,
WHERE ._ IN
(SELECT ._ FROM , AS Projects WHERE ( Projects._ = ._ AND Projects. = P. ))
GROUP BY P.;