VbzCart/queries/qryItTypsDepts ItTyps
Jump to navigation
Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
About
- Requires:
- REDIRECT Template:l/vc/query,
- REDIRECT Template:l/vc/table
- Used by: catalog Supplier page
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>