ID Number: Q80398
1.10 1.11
OS/2
Summary:
SYMPTOMS
A view created using a subquery cannot be updated. An attempt to
update a view created with a subquery generates the following
message:
View <view_name> is not updatable because it contains aggregates.
(Msg 4403, Level 16, State 1).
CAUSE
This is similar to the case where a view created with an aggregate
cannot be updated. This happens because the subqueries are
processed as a special type of aggregate, and therefore few
significant differences exist between aggregate and subquery
processing.
According to ANSI (X3.135-1989), a view cannot be updated if it
includes a subquery.
Additional reference words: 1.10 1.11