. , .
SELECT ., Max (.[ ]) AS [Max- ], Min (.[ ]) AS [Min- ]
FROM INNER JOIN ON .[N ] = .[N ]
GROUP BY .
HAVING .="";
54: , . : , ,. .. .
.
, . . , . ().
.17.
ANSI SQL:
SELECT ., ., .
FROM INNER JOIN ( INNER JOIN ON . = .) ON . = .
WHERE (.)>(SELECT Avg () FROM );
SELECT . AS [ ], . AS [ ], .[ ]
FROM INNER JOIN ON .[N ] = .[N ]
WHERE (((.[ ])>(SELECT Avg([ ]) FROM )));
.
4.1: 54
. . . OK.
. , . SLQ INTO.
SELECT ., .,
. INTO [ ]
FROM
SELECT . AS [ ],
|
|
. AS [ ],
.[ ] INTO [ ]
FROM
. , 43 . . (F11) , .