DELETE FROM QTY
WHERE exists
(SELECT 1 FROM SKU, LOC, ITEM
WHERE SKU.LOC_ID = LOC.LOC_ID
AND SKU.ITEM_ID = ITEM.ITEM_ID
AND LOC_NAME = 'US'
AND SKU.SKU_ID = QTY.SKU_ID );
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.