VbzCart/queries/qryCtg src

About

 * Requires: ,
 * Used by: catalog building process (details to be documented)
 * History:
 * 2008-03-15 Building sequence completely rewritten, so presumably this query was created then
 * 2008-04-02 convert blanks to nulls in b.ItOpt_Descr_part
 * 2010-12-29 Added t.ID_Supplier because now needs that field set.
 * 2011-01-02 Added t.Name (AS TitleName) for the same reason
 * Fields:
 * b.ItOpt_Descr_part apparently often comes up as "" rather than NULL, so we have to convert blanks to nulls before testing for null.

SQL
CREATE OR REPLACE VIEW qryCtg_src AS SELECT b.*, t.ID_Supplier, t.Name AS TitleName, CONCAT_WS('-',b.ID_Title,b.CatSfx) AS IDS_Item, CONCAT_WS('-',t.CatNum,b.CatSfx) AS CatNum, IFNULL(NULLIF(b.ItOpt_Descr_part,""),b.NameSng) AS ItOpt_Descr FROM qryCtg_src_sub AS b LEFT JOIN qryCat_Titles AS t ON b.ID_Title=t.ID;