, . , -. . 6.19 DatePlaced StatusID .
, -, , ? , . (, . 6.19 Toby.) , Access Customers . , "Toby" "" . 6.19, Access .
, . , , Toby, , , Lisa. FirstName LastName. ( , Toby Customers.) CustomerID Orders , . , . 6.19, CustomerID , .
, , , (inner join). , , . Customers Orders, ,
. , ( CustomerID) ( CustomerID, Customers).
(outer join) ( ) . , , , .
, Orders Customers, , . , , ( FirstName LastName) . 6.1.
6.1. Orders Customers:
|
|
FirstName | LastName | ID | DatePlaced | StatusID |
Stanley | Lem | 13-Jun-07 | Cancelled | |
Toby | Grayson | 03-NOV-06 | Returned | |
Toby | Grayson | 03-Nov-06 | Shipped | |
01-Jan-08 | In Progress | |||
01 -Jan-08 | In Progress |
, . ( , , .) , .
- , CustomerID (. . " " 4) (. . " " 5).
Orders Customers, . , (. 6.2).
6.2. Orders Customers:
FirstName | LastName | ID | DatePlaced | StatusID |
Stanley | Lem | 13-Jun-07 | Cancelled | |
Toby | Grayson | 03-NOV-06 | Returned | |
Toby | Grayson | 03-Nov-06 | Shipped |
6.2 ()
FirstName | LastName | ID | DatePlaced | StatusID |
Ben | Samatara | |||
Goosey | Mason | |||
Tabasoum | Khan |
. , ? ( Access , . . " " ), . , , (Join Properties) ( ). (. 6.20), .
. 6.20. , . ,
. , , : , (unmatched records).
, , . . , . , .
|
|
, . : , (ID) . (null) .
. 6.21. , . , . , ID ,
. 6.22. . Products ProductCategories, Suppliers (), ,
, ID Orders:
IS Null
, Access , , . . 6.21 .
, Access . . , . , , .
. 6.23. , , Orders, Customers - Orders, . , , ,
. , . , , , , . Access , , .
. 6.22 , - , .
. 6.24. , , , . ,
, . OrderDetails, Boutique Fudge . OrderDetaits , ,
(. . " " 5, ). , , OrderDetails, Orders Customers, . 6.23.
, "--" (. . " "--"" 5), . 5, Cacophone Studios . , , , : Classes, Teachers Teachers_Classes (. 6.24).
|
|
7