begin
begin TRANSACTION
update matrimony_Personaldetails set Profilecreatedby='self',Name='manu'FROM matrimony_Personaldetails mp1 inner join matrimony_register mr on mr.Reg_id=mp1.Reg_id where mp1.Reg_id=@regId
update matrimony_register set Height='5 ft- 4in' from matrimony_register mr INNER JOIN matrimony_Personaldetails mp1 ON MR.Reg_id=mp1.Reg_id where mp1.Reg_id=@regId
commit
select mp1.Profilecreatedby,mp1.Name,mr.Height from dbo.matrimony_Personaldetails as mp1 left outer join dbo.matrimony_register as mr on mr.Reg_id=mp1.Reg_id where mp1.Reg_id=@regId