I need help with this update statement. Can someone please tell me the correct syntax.
UPDATE tblHousehold set lnghouseid =
(select P.lnghouseid from tblpatient as P inner join tblHousehold as H on
P.lngHouseid = H.lngHouseid where P.lngpatientid = '6505')
from tblPatient as P1 inner join tblhousehold as H1 on P1.lnghouseid = H1.lnghouseid
where P1.lngPatientID = '62061'