. , , AdventureWorks.
1. , (join query).
Orderedltem , , , , . . , , . . " " 6.
, , .
2. → → (Create → Other → Query Wizard).
. (New Query) , .
3. (Crosstab Query Wizard) .
(. 9.4). (View).
4. . , , . .
OrderedItems.
, (. 9.5).
. 9.4. ,
. 9.5. >
, ( ). . , . , , () . . . 9.2.
5. , , .
Orderedltems State Province. , . , , StateProvince Country. , . " " .
|
|
, (. 9.6). .
. 9.6. Access - . StateProvince, ProductCategory
6. . ProductCategory.
, .
(. 9.7). , , , . . OrderQty.
. 9.7. Sum OrderQty . , , 53 Bike () . , ( ), Count SalesOrderID