Hi,
U have to update all the variable values to ur table based on JOIN right...
Check the following Code....
update O SET set O.Department=@Department,O.Doctor=@Doctor,O.ReffBy=@ReffBy,O.Diagnosis=@Diagnosis,O.Category=@Category,O.MLC=@MLC,O.PoliceStation=@PoliceStation,
O.FIRno=@FIRno,O.Identification=@Identification,O.Injury=@Injury,O.Singnature=@Signature,O.MLC_Charge=@MLC_Charge,O.Willing=@Willing,
O.Remark=@Remark,O.broughtby=@broughtby,O.contactno=@contactno,O.DoctorFee=@DoctorFee,O.AddFee=@AddFee,O.Reason=@Reason,O.Discount= @Discount
O.AdmitDate=@AdmitDate
FROM OpdPatient as O
inner join Registration as R on O.RegNo=R.RegNo
where O.RegNo=@PID
Regards,
GVPrabu