需求:
表A字段:company_id,phone
表B字段:company_id,phone
把表B的phone字段更新到表A的phone字段中,条件就是company_id相等。
UPDATE A t1
SET phone = ( SELECT t2.PHONE FROM B t2 WHERE t1.COMPANY_ID = t2.COMPANY_ID )
WHERE
EXISTS ( SELECT 1 FROM B t2 WHERE t2.COMPANY_ID = t1.COMPANY_ID )