VbzCart/queries/qryTitles ItTyps ItTyps
from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
About
- Requires: qryTitles_ItTyps_grpItems, 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 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 />
