Database Reference
In-Depth Information
How it works...
The schema is similar to the map of a city. Using the city as an analogy, even if you have a
map, you need to have the means to travel to your favorite destination. The mode of travel
in the schema city is the use of SQL queries. The recipe discusses the schema and provides
example queries on how to extract the information you need. The additional points to note
in this recipe are the use of
Joins
and
aliases
. The joins in the queries connect views
and aliases, provide short names to make the queries easier to read.
Appendix
,
Useful Web-
sites, Chapter Code, and Community Resources
, provides links to additional resources, in-
cluding the SQL query syntax.
