VbzCart/queries/qryTitles ItTyps ItTyps: Difference between revisions

Revision as of 12:33, 13 April 2009

Requires: qryTitles_ItTyps_grpItems, cat_ittyps
Used by: catalog title pages
History:
- 2009-04-13 had to recreate because qryTitles_ItTyps_grpItems changed

<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryTitles_ItTyps_ItTyps AS SELECT

 i.*,
 it.Sort                       AS ItTyp_Sort,
 it.NameSng                    AS ItTyp_Sng,
 IFNULL(it.NamePlr,it.NameSng) AS ItTyp_Plr

FROM qryTitles_ItTyps_grpItems AS i LEFT JOIN cat_ittyps AS it ON i.ID_ItTyp=it.ID;</mysql> <section end=sql />

@@ Line 1: / Line 1: @@
+==About==
+* '''Requires''': {{vbzcart/query|qryTitles_ItTyps_grpItems}}, {{vbzcart/table|cat_ittyps}}
+* '''Used by''': catalog title pages
+* '''History''':
+** '''2009-04-13''' had to recreate because qryTitles_ItTyps_grpItems changed
 ==SQL==
 <section begin=sql /><mysql>CREATE OR REPLACE VIEW qryTitles_ItTyps_ItTyps AS