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