|
Search Database #2 (SQL Where clause
examples)
For our next examples, knowing the structures of the tables
will be helpful.
The authors database has a structure like this:
The titles database has a structure like this:
| Title |
Year_Published |
ISBN |
PubID |
Description |
Notes |
Subject |
Comments |
The Title_Author table looks like this:
The publisher' database has a structure like this:
| PubID |
Name |
Company_Name |
Address |
City |
State |
Zip |
Telephone |
Fax |
Comments |
|