We
can update view, if the view is created with one table.
But we cannot update view if the view is created with more than one table with multiple columns because view is single virtual table created multiple columns from different tables. so we cannot update this virtual table.
But we cannot update view if the view is created with more than one table with multiple columns because view is single virtual table created multiple columns from different tables. so we cannot update this virtual table.