VbzCart/queries/qryItTypsDepts ItTyps

About

 * Requires: ,
 * Used by: catalog Supplier page

SQL
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;