VbzCart/queries/qryCbx Items data
Jump to navigation
Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
Details
- Requires: qryCat_Items
- Used by:
SQL
<mysql>CREATE OR REPLACE VIEW qryCbx_Items_data AS SELECT
i.ID, CAST( CONCAT( if(i.isPulled, '*P* ', ), if(i.CatNum IS NULL, CONCAT('#',i.ID,' (no cat#)') ,i.CatNum), if(i.Supp_CatNum IS NULL, , CONCAT(' [',i.Supp_CatNum,']') ), if(i.isForSale,,' *n/a*'), ' ', if(i.Descr IS NULL,'no description',i.Descr) ) AS CHAR ) AS Descr, i.isPulled, i.isForSale, i.ID_Title, i.CatNum, i.Supp_CatNum, i.PriceSell, i.QtyMin_Stk
FROM qryCat_Items AS i ORDER BY NOT i.isPulled, i.isForSale, i.CatNum;</mysql>