VbzCart/docs/queries/qryTitles ItTyps ItTyps

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