No it will not update in both the table.Only one table will be update Create View asp_vwAS (Select h.First_name,h.salary,A.first_name as Test,A.date_of_birth from honey h left join ashu A on h.first_name=A.first_name)Select * from asp_vw Update asp_vw set first_name = 'parkash1'
No it will not update both the tables. it will update only one table.
Yes It will be Updated .If you did not have WITH CHECK OPTION defined in View, the UPDATE statement would succeed,
1) Yes 2) No Why ??