VbzCart/docs/queries/qryTitles ItTyps ItTyps: Difference between revisions

From Woozle Writes Code
< VbzCart‎ | docs‎ | queries
Jump to navigation Jump to search
imported>Woozle
(moved from single-page listing)
 
imported>Woozle
(some documentation)
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==
==SQL==
<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryTitles_ItTyps_ItTyps AS
<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryTitles_ItTyps_ItTyps AS

Revision as of 12:33, 13 April 2009

About

SQL

<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 />

Retrieved from "https://wooz.dev/mw/index.php?title=VbzCart/docs/queries/qryTitles_ItTyps_ItTyps&oldid=5416"