VbzCart/queries/qryItems prices

Details

 * Requires: cat_items, cat_ittyps
 * Used by:
 * Future: This will eventually contain shipping prices as well, but the shipping costs table hasn't been migrated as of this writing. It also needs to build a description from it.NameSng and i.ItOpt_Descr -- or perhaps there is a better way to do it (haven't we solved this problem elsewhere in a view?)

SQL
CREATE OR REPLACE VIEW qryItems_prices AS SELECT i.ID, i.CatNum, i.ID_Title, i.ID_ItTyp, i.ID_ShipCost, i.PriceSell, i.PriceList, i.ItOpt_Descr, i.isInPrint, it.NameSng, it.NamePlr, it.Descr as ItTyp_Descr FROM (cat_items AS i LEFT JOIN cat_ittyps AS it ON i.ID_ItTyp=it.ID) WHERE i.isForSale AND (NULLIF(i.isPulled,0) IS NULL) AND (i.ID_ShipCost IS NOT NULL) AND (i.PriceSell IS NOT NULL) ORDER BY i.CatNum;