VIEW acts very much like a table. Although you can
UPDATE a table, you may or may not be able to update a view into that table. In general, if the
SELECT in the view is complex enough to require a temp table, then
UPDATE is not allowed.
DISTINCT, and some subqueries prevent the view from being updatable. Details in reference manual.