view based on joins

Question

Hi It is possible Can we insert into views that are based on joins? Thanks

Arjun Panwar · Answer

Hi Senthil Is it possible in mysql server?

Senthilkumar · Answer

As per as my knowledge as concerned it is not possible to insert. If view belongs to one table then it can be possible. Because the sql server views do not have the mechanism to classify the referential integrity while insert into the view when it has multiple tables.

Satyapriya Nayak · Answer

Hi Arjun Please refer the below link http://www.codeproject.com/Articles/236425/How-to-insert-data-using-SQL-Views-created-using-m?display=Print Thanks