摘要： UPDATE pnc SET pnc.status = 3 from pc_nc_case pnc WHERE pnc.pc_nc_case_id = (SELECT TOP 1 pnch.pc_nc_case_id FROM pc_nc_case_history pnch WHERE pnc.pc_nc_case_id = pnch.pc_nc_case_id AND pnch.status=3 ORDER BY pnch.pc_nc_case_history_id DESC)AND pnc.status = 1--婚姻狀況update m set m.marr_status=d.id fr 阅读全文