Access.
, , , . , , , . , 4 . , , - . (. 5). . .
, . . , -- (. , . 4.). . 6. , , , .
, --. (.7), .
, . . , . , .
.
, . .
, , , , . . , . . , . , , , , . Access , , , , .
|
|
, . , , , , . , . , , . , . . .
. , . . , . . . , .
, . . 8. , , . , . , , . , . 9. , . 3 . , . . , , . .
, , , . , . , .10. , . Column(0) .
. , . . , , .
.
SELECT [2].[], [2].[], [2].[], [2].[] FROM 2;
|
|
SELECT [].[], [].[] & " " & left([].[],1) & "." & left([].[],1) & ".", [].[] FROM ;
2
SELECT ., ., ., .
FROM INNER JOIN ON . = .;
, SQL. , SQL, . .
. , . 9.
.
Access , Select, SQL(Structured Query Language). . :
Select <_>
From <_>
[Where< __>]
[Group by <_>]
[Having <__>]
[Order by <_>]
. , , (.10),
[].[] & " " & left([].[],1) & "." & left([].[],1) & ".", .
From , , Select. , From inner join, . :
FROM _1 INNER JOIN _2 ON _1._1 _2._2
2, .
SELECT ., ., ., .
FROM INNER JOIN ON . = .;
. JOIN ; :
SELECT
FROM _1 INNER JOIN (_2 INNER JOIN
( 3 ON _2._2 _3._3)
ON _1._1 _2._2;
WHERE , , From, Select. WHERE . , , . :