SELECT
Microsoft Access .
SELECT [ ] { * | . * | [ . ] 1 [AS 1 ] [, [ . ] 2 [AS 2 ] [,...]]}
FROM _ [,...] [IN __ ]
[WHERE... ]
[GROUP BY... ]
[HAVING... ]
[ORDER BY... ]
[WITH OWNERACCESS OPTION]
SELECT .
| : ALL, DISTINCT, DISTINCTROW TOP. . , ALL. | |
| * | , |
| , | |
| 1, 2 | , . , |
| 1, 2 | , |
| _ | , . |
| __ | , , _, |
Microsoft Access (), , , , .
SELECT .
SELECT SQL. SQL SELECT, SELECT...INTO.
SELECT :
SELECT FROM
(*). .
SELECT * FROM ;
FROM, . (). . SQL .
SELECT ., . FROM INNER JOIN WHERE . = .;
RecordSet Microsoft Access RecordSet. , , AS. , RecordSet.
SELECT AS FROM ;
, , AS . RecordSet .
SELECT COUNT() AS FROM ;
SELECT . . , .
