Sunday, February 26, 2012

Error Update

Hi,
I create the View which consist of multiple same table. When I want to update via the View, it doesn't allow me to update it, it gave out the following message,
View or function 'Table1' is not updatable because the modification affects multiple base tables.What do you mean by "multiple same table"? If you're saying the view has self-joins, then the view is not going to be updatable.

No comments:

Post a Comment