UPDATE patientinsurance dest JOIN ( SELECT patientCode, policyNo FROM patientinsurance WHERE ID = 121590 ) AS source ON dest.patientCode = source.patientCodeSET dest.policyNo = source.policyNoWHERE dest.id IN (121911)
No comments:
Post a Comment