VbzCart/docs/queries/qryItTypsDepts ItTyps

About

• Requires: Template:Vbzcart/query, Template:Vbzcart/table
• Used by: catalog Supplier page

SQL

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

 m.*,
 it.NameSng AS ItTyp_Sng,
 it.NamePlr AS ItTyp_Plr

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