VbzCart/queries/qryCat Items Stock
from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
About
- Requires: cat_items, v_stk_items_remaining
- Used by: qryItTypsDepts grpItems
- Notes: This may turn out to be inefficient, since it retrieves a lot of data which may not be needed
- History:
- 2009-04-12 Created to replace cat_items.qtyInStock field
SQL
<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryCat_Items_Stock AS SELECT
i.*, SUM(st.qtyForSale) AS qtyForSale, SUM(st.qtyForShip) AS qtyForShip
FROM (cat_items AS i LEFT JOIN v_stk_items_remaining AS st on i.ID=st.ID_Item) GROUP BY i.ID;</mysql> <section end=sql />
