Question

what are the condition for a view to be an update able value​

Answer 1

Answer:

If the view contains joins between multiple tables, you can only insert and update one table in the view, and you can't delete rows. You can't directly modify data in views based on union queries. You can't modify data in views that use GROUP BY or DISTINCT statements.

Answer 2

Answer:

Using Views to Update Data: ** A view can be used in a query that updates data, subject to a few restrictions. ... If the view contains joins between multiple tables, you can only insert and update one table in the view, and you can't delete rows. You can't directly modify data in views based on union queries.

Explanation:

Follow Me...❤❤❤