VbzCart/queries/qryItTypsDepts grpItems
from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
About
- Requires: qryCat_Items_Stock, cat_titles
- Used by: qryItTypsDepts_ItTyps
- History:
- 2009-04-12 No longer caching stock-quantity fields in cat_items, so had to pull in
v_stk_items_remainingqryCat_Items_Stock; removing cntStkForSale until I find out what it is needed for
- 2009-04-12 No longer caching stock-quantity fields in cat_items, so had to pull in
SQL
<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryItTypsDepts_grpItems AS SELECT
i.ID_ItTyp, t.ID_Dept, SUM(IF(i.isForSale,1,0)) AS cntForSale, SUM(IF(i.isInPrint,1,0)) AS cntInPrint, /* SUM(IF(i.QtyForSale>0,1,0)) AS cntStkForSale, */ SUM(i.qtyForSale) AS qtyForSale
FROM qryCat_Items_Stock AS i LEFT JOIN cat_titles AS t ON i.ID_Title=t.ID GROUP BY i.ID_ItTyp, t.ID_Dept HAVING cntForSale;</mysql> <section end=sql />
