. . . :
SELECT < > INTO < >
FROM < > [WHERE < >].
, SELECT, , . ,
SELECT ., ., . INTO FROM WHERE .[ ]>#1984/01/04#;
TRANSFORM . (), , , .
TRANSFORM :
TRANSFORM ( )
SELECT GROUP BY ( )
PIVOT , .
, . , , .
2002 | 2002 | 2002 | 2002 | |
TRANSFORM Sum(.* .) AS
SELECT . FROM INNER JOIN ON . = . WHERE .[ ] BETWEEN #2002/1/1# And #2002/30/4# GROUP BY .
PIVOT Format([ ],"mmm yyyy");
PIVOT DatePart("m",[],1,0), .
UNION SELECT ( ). . , SELECT, , . SELECT ( ). SELECT . . ORDER BY, SELECT:
|
|
SELECT & & & & As , FROM
UNION SELECT , FROM
ORDER BY , ;
UNION SQL2 : EXCEPT ( . R , A B) INTERSECT ( . R , A, B). , () .