Can we update views.If not,why?

Hi,
we can update view .if the view is created with one table.
But we canot update view if the view is created with more than one table with multiple columns.why because view is single virtual table created multiple columns from diffrent tables. so we canot update this virtual table i.e view.when we selected multiple tables and mutiple columns.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.