VbzCart/queries/qryCat Titles

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
< VbzCart‎ | queries
Revision as of 22:04, 6 November 2010 by Woozle (talk | contribs) (changing CatKey_Title back to CatKey)
Jump to navigation Jump to search

Details

  • Requires: cat_titles, qryCat_Depts
  • 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

SQL

<mysql>CREATE OR REPLACE VIEW qryCat_Titles AS 

 SELECT
   t.ID,
   t.Name,
   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;</mysql>

Retrieved from "https://htyp.org/mw/index.php?title=VbzCart/queries/qryCat_Titles&oldid=14385"