Errata

Print Print Icon

Submit your own errata for this product.


The errata list is a list of errors and their corrections that were found after the product was released.

The following errata were submitted by our customers and have not yet been approved or disproved by the author or editor. They solely represent the opinion of the customer.

Color Key: Serious Technical Mistake Minor Technical Mistake Language or formatting error Typo Question



Version Location Description Submitted By
Printed Page 57
1st paragraph

In the UPDATE example:

UPDATE enrollment e
SET (course_name, period) = (
SELECT course_name, period
FROM course c
WHERE c.course_name = e.course_name
AND c.period = e.period);

because aliases have been used for "enrollment" and "course", isn't it required to use the alias "e" for columns being SET and "c" for columns in the SELECT?

Shouldn't the UPDATE example be as follows?

UPDATE enrollment e
SET (e.course_name, e.period) = (
SELECT c.course_name, c.period
FROM course c
WHERE c.course_name = e.course_name
AND c.period = e.period);

 Anonymous