select a.ID_NO, * from tf_pos a inner join mf_bom b on a.prd_no = b.prd_no and a.PRD_MARK=b.prd_mark
where a.id_no<>b.bom_no
UPDATE TF_POS SET ID_NO='' from tf_pos a inner join mf_bom b on a.prd_no = b.prd_no and a.PRD_MARK=b.prd_mark
where a.id_no<>b.bom_no
(14453 行受影响)
(11563 行受影响)