Updating a table via a VIEW

A 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.

Things like GROUP BY, UNION, HAVING, DISTINCT, and some subqueries prevent the view from being updatable. Details in reference manual.