SELECT kontra UPDATE im SQL? Über zwei Tabellen?

[jaenicke]

Schau mal hier:
http://en.wikipedia.org/wiki/Update_(SQL)

Zitat:

The SQL:2003 standard does not support updates of a joined table. Therefore, the following method needs to be used. Note that the subselect in the SET clause must be a scalar subselect, i.e., it can return at most a single row.

Das Beispiel müsste das ja sein.