Did you mean Only Joins ? --Update using Joinupdate c set c.Fee=1000from [t_Course] c join [t_Mapping] mon c.course_name=m.course_namewhere m.stud_id=1-- Delete using join delete s from [t_Student] s join [t_Mapping] mon s.id=m.stud_idwhere m.stud_id=3