SQL 更新两个表数据：person_info 和 PERSON_INFO_TC_04TCTH

UPDATE person_info p SET p.xb = (SELECT t.xb FROM PERSON_INFO_TC_04TCTH t WHERE t.pid = p.pid), p.mz = (SELECT t.mz FROM PERSON_INFO_TC_04TCTH t WHERE t.pid = p.pid), p.hkssqx = (SELECT t.hkssqx FROM PERSON_INFO_TC_04TCTH t WHERE t.pid = p.pid), p.hkxxdz = (SELECT t.hkxxdz FROM PERSON_INFO_TC_04TCTH t WHERE t.pid = p.pid);