VbzCart/queries/qryItems needed forStock
from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
About
- History:
- 2010-01-02 Created
- Used by: VbzAdminStkItems::Needed() - restock request creation in VbzAdmin
- Requires: qryStkItms_for_sale
SQL
<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryItems_needed_forStock AS SELECT
i.ID, i.QtyMin_Stk, s.QtyForSale
FROM cat_items AS i
LEFT JOIN qryStkItms_for_sale AS s ON s.ID_Item=i.ID
WHERE i.isForSale AND ((i.QtyMin_Stk - s.QtyForSale) > 0);</mysql> <section end=sql />
