Table of Contents
Central District Clinic
Recall The CDC Design ...
Queries
A Query
Queries Do More Than Save Columns
Specifying The Criteria For Testing
Changes To The Query Are Visible
Another Example
The Basic Query
Finishing Query With Selections
Joining Tables Together
Build A Table Summarizing Tests
Must Be More Selective
At The CDC, Form Today’s Tests
The SQL For Today
The Table From The Today Query
Making The Manifest
Wrapping Up Today
|
Author: Snyder
Email: snyder@cs.washington.edu
Home Page: http://www.cs.washington.edu/homes/snyder/
|