VbzCart/queries/qryCbx Items opt
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
- Purpose: An abbreviated version of qryCbx_Items for contexts where the Title is already known
- Requires: cat_items, cat_ioptns
SQL
<mysql>CREATE OR REPLACE VIEW qryCbx_Items_opt AS SELECT
i.ID,
CAST(
CONCAT(
if(i.isPulled,
'*P* ',
),
if(i.ID_ItOpt IS NULL,
CONCAT('#',i.ID,' (no opt)')
,io.CatKey),
if(i.isForSale,,' *n/a*')
) AS CHAR
) AS Descr,
i.CatNum
FROM cat_items AS i LEFT JOIN cat_ioptns AS io ON i.ID_ItOpt=io.ID;</mysql>