26-03-2024, 10:47 AM
UPDATE STOCKS
SET STOCKS.QUANTSTQ =STOCKS.QUANTSTQ-(SELECT BONS.QUANTETE FROM BONS WHERE STOCKS.BARCODE = BONS.BARCODE)
WHERE STOCKS.QUANTSTQ >=
(SELECT BONS.QUANTETE FROM BONS WHERE STOCKS.BARCODE = BONS.BARCODE)
SET STOCKS.QUANTSTQ =STOCKS.QUANTSTQ-(SELECT BONS.QUANTETE FROM BONS WHERE STOCKS.BARCODE = BONS.BARCODE)
WHERE STOCKS.QUANTSTQ >=
(SELECT BONS.QUANTETE FROM BONS WHERE STOCKS.BARCODE = BONS.BARCODE)
وقل ربي زدني علماً

