UPDATE b
SET minitqty =
(SELECT trxqtysum+b.minitqty
FROM a
WHERE b.wno = a.wno
AND b.mcd = a.mcd
AND TRIM (b.wno) = TRIM (vs_wno)
)
WHERE EXISTS (
SELECT 'X'
FROM a
WHERE b.wno = a.wno
AND b.mcd = a.mcd
AND TRIM (b.wno) = TRIM (vs_wno));
SET minitqty =
(SELECT trxqtysum+b.minitqty
FROM a
WHERE b.wno = a.wno
AND b.mcd = a.mcd
AND TRIM (b.wno) = TRIM (vs_wno)
)
WHERE EXISTS (
SELECT 'X'
FROM a
WHERE b.wno = a.wno
AND b.mcd = a.mcd
AND TRIM (b.wno) = TRIM (vs_wno));
SET b.minitqty =
( (SELECT trxqtysum+b.minitqty ---报错行
FROM a
WHERE b.wno = a.wno
AND b.mcd = a.mcd
AND TRIM (b.wno) = TRIM (vs_wno))
)
WHERE EXISTS (
SELECT 1
FROM a
WHERE b.wno = a.wno
AND b.mcd = a.mcd
AND TRIM (b.wno) = TRIM (vs_wno));