34,593
社区成员
发帖
与我相关
我的任务
分享
UPDATE b
INNER JOIN a
ON A.qty<>B.qty
AND A.item_no=B.item_no
SET B.flag = 'F9', B.before_qty = A.qty
WHERE A.flag='0'
再试试,不行到ACCESS版提问。UPDATE b
INNER JOIN a ON A.flag='0'
AND A.qty<>B.qty
AND A.item_no=B.item_no
SET B.flag = 'F9', B.before_qty = A.qty
UPDATE B
SET flag='F9',B.before_qty=A.qty
FROM A
WHERE A.flag='0' AND A.qty<> B.qtY AND A.item_no=B.item_no
UPDATE B SET flag='F9',B.before_qty=A.qty
FROM A WHERE A.flag='0' AND A.qty<> B.qtY AND A.item_no=B.item_no
UPDATE b
SET B.flag = 'F9', B.before_qty = A.qty
FROM a
WHERE A.flag = '0'
AND A.qty<>B.qty
AND A.item_no = B.item_no