VbzCart/queries/qryCat Titles

Details

 * Status: DEPRECATED -- does not retrieve titles that have no department. Departments are being discontinued, so this is a problem.
 * Requires: ,
 * Fields:
 * CatKey is used in the catalog-building process (Enter Title Groups) when searching within a supplier for a particular title
 * History:
 * 2010-11-06 Changed CatKey_Title back to CatKey because "Title" should be the default context for this query
 * 2011-01-29 Added "t.Desc AS Descr" and "t.Search" to help with searching; t.Desc should eventually be renamed to t.Descr because "DESC" is an SQL keyword
 * 2012-03-05 DEPRECATED - should be removed from database and all pages checked to make sure they still work

SQL
CREATE OR REPLACE VIEW qryCat_Titles AS SELECT t.ID, t.Name, t.Desc AS Descr, t.Search, UPPER(CONCAT_WS("-",d.CatNum,t.CatKey)) AS CatNum, LOWER(CONCAT_WS("/",d.CatWeb_Title,t.CatKey)) AS CatWeb, t.CatKey, d.ID_Supplier, t.ID_Dept, t.DateAdded, t.RstkMin AS QtyMin_Rstk, t.Notes, t.Supplier_CatNum AS Supp_CatNum FROM cat_titles AS t LEFT JOIN qryCat_Depts AS d ON t.ID_Dept=d.ID;