Update Record in two Table using trigger

[ranjana1980]

Hi All,
I have two tables One is Student And another is AcademicQualifi cation.In first table RegNo is primary key and in second one it is foreign key then how to create trigger to update table where Student.RegNo = AcademicQualifi cation.RegNo

[amitpatel66]

Why you need a trigger to update the values in the tables....a simple update statement will suffice

[ranjana1980]

Why you need a trigger to update the values in the tables....a simple update statement will suffice

simple update statement using two tables not work .

update Student as s,AcademicQuali fication as a set s.FName='Maya', s.LName='Sharma ',a.InstituteNm ='St Joseph',a.Unive rsity='Barkatul lah' where s.RegNo==a.Regn o