VbzCart/queries/qryCat Depts

About

 * Requires: ,
 * History:
 * 2008-12-11 Added isActive field (from ) so that can show only active depts

SQL
CREATE OR REPLACE VIEW qryCat_Depts AS SELECT d.ID, d.Name, d.Sort, d.CatKey, UPPER(IFNULL(d.PageKey,d.CatKey)) AS CatKey_def, d.isActive, d.ID_Supplier, UPPER(CONCAT_WS('-',s.CatKey,d.CatKey)) AS CatNum, LOWER(CONCAT_WS("/",s.CatKey,IFNULL(d.PageKey,d.CatKey))) AS CatWeb_Dept, LOWER(CONCAT_WS("/",s.CatKey,d.CatKey)) AS CatWeb_Title FROM cat_depts AS d LEFT JOIN cat_supp AS s ON d.ID_Supplier=s.ID;