: -10
..
: ..
2012
\ | ||||
MS Access | ||||
MS Access | ||||
, MS Access | ||||
1
Ļ
: . . .
:
1) .
2) , .
3) ( ).
2
: ACCESS
: : MS ACCESS.
3
MS Access
4
, MS Access
2
.
.
: , .
1)
:
3
4 9.
4 9.
|
|
5
.
,
6
DELETE ._
FROM
WHERE (((._)="0"));
UPDATE SET . = ""
WHERE (((.)=""));
INSERT INTO (_, _)
SELECT .[ ] AS 1, .[ ] AS 2;
7
INNER JOIN
SELECT ._, ._, ._, ., ., ._, ._, .
FROM INNER JOIN ON .[_]=._;
RIGHT JOIN
SELECT ._, ._, ._, ., ., ._, ._, .
FROM RIGHT JOIN ON ._=._;
LEFT JOIN
SELECT ._, ._, ._, ., ., ._, ._, .
FROM LEFT JOIN ON ._=._;
SELECT ., ., ._, ._
FROM INNER JOIN ( INNER JOIN ON ._ = ._) ON ._ = .;
8
MAX
SELECT MAX (_) AS [ ]
FROM ;
Min
SELECT ._, Min(._) AS [Min-_], ._
FROM
GROUP BY ._, ._;
Count
SELECT Count(._) AS [Count-_], ._, ._
FROM
GROUP BY ._, ._;
Avg
SELECT ._, Avg(._) AS _
FROM
GROUP BY ._;
9