根据B表,更新A表对应记录
UPDATE A
SET (A.3, A.4) = (SELECT B.3, B.4
FROM B
WHERE A.1=B.1 AND A.2=B.2)
WHERE EXISTS (SELECT 1
FROM B
WHERE A.1=B.1 AND A.2=B.2)
根据B表,更新A表对应记录
UPDATE A
SET (A.3, A.4) = (SELECT B.3, B.4
FROM B
WHERE A.1=B.1 AND A.2=B.2)
WHERE EXISTS (SELECT 1
FROM B
WHERE A.1=B.1 AND A.2=B.2)