Head First SQL
by Lynn Beighley

This errata page lists errors outstanding in the most recent printing.

If you have technical questions or error reports, you can send them to
booktech@oreilly.com.  Please specify the printing date of your copy.

This page was updated May 12, 2008.

Here's a key to the markup:
	[page-number]: serious technical mistake
	{page-number}: minor technical mistake
	<page-number>: important language/formatting problem
	(page-number): language change or minor formatting problem
	?page-number?: reader question or request for clarification



Confirmed errors:

(333, 335) Sharpen Your Pencil Instructions

Add another sentence to the end of the third paragraph of the Sharpen Your Pencil instructions that says, "You may have to create new toy_ids."

{370} The first and third queries on this page should use a NATURAL JOIN. The INNER JOIN will produce the wrong results.

Changed "INNER" to "NATURAL" in first and third answers.

{378} Sharpen your pencil - Solution;
The annotation for the table states, "The interests column is empty after we run the command."  This is incorrect. The interests column still has the value "fourth" in it.

The annotation on the bottom of the page was changed to read "The interests column contains only the last interest at this point."  Additionally, in the interests column on the table, the scratchy line was edited to only cross out the second and third part, leaving the fourth part unscratched.

{381}  Old tables in the ER diagram;  
contact_interest.interest_id should link up with interests.interest_id 
and 
contact_seeking.seeking_id should link to seeking_id

To correct this, I edited the arrow paths:
The right arrow that points at contact_interest.contact_id was shifted down to contact_interest.interest_id. 
The right arrow that points at contact_seeking.contact_id was shifted down to contact_seeking.seeking_id.

{472} SQL for creating view:
The AS keyword is in the wrong place.  AS in the statement was moved after pb_quarters, to read:

CREATE VIEW pb_quarters AS
SELECT...