VbzCart/queries/qryStock by Supp Type Opt

About

 * Returns: Stock totals by supplier+itemtype+itemoption
 * Requires:, , ,
 * Used by: nothing yet; thought this was going to be for the stock-by-size index page, but realized that should be (no Supp)
 * History:
 * 2008-12-09 Rewritten almost from scratch (loosely based on existing Access query), not sure how the old one worked

SQL
CREATE OR REPLACE VIEW qryStock_by_Supp_Type_Opt AS SELECT t.ID_Supplier, io.CatKey, it.NameSng AS TypeSing, IFNULL(it.NamePlr,it.NameSng) AS TypePlur, SUM(stk.QtyForSale) AS QtyForSale, Count(it.ID) AS TypeCount FROM (((cat_ioptns AS io       LEFT JOIN cat_items AS i ON i.ID_ItOpt=io.ID) LEFT JOIN qryCat_Titles AS t ON i.ID_Title=t.ID)   LEFT JOIN cat_ittyps AS it ON i.ID_ItTyp=it.ID) LEFT JOIN qryStkItms_for_sale AS stk ON i.ID=stk.ID_Item GROUP BY t.ID_Supplier, it.NamePlr, it.NameSng, io.CatKey HAVING QtyForSale;