VbzCart/queries/qryCat Depts
from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
About
- Requires: cat_depts, cat_supp
- History:
- 2008-12-11 Added isActive field (from cat_depts) so that qryCbx_Depts can show only active depts
SQL
<section begin=sql /><mysql>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;</mysql>
<section end=sql />
