VbzCart/queries/qryStk lines Title info

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
< VbzCart‎ | queries
Revision as of 02:23, 4 December 2008 by Woozle (talk | contribs) (New page: ==Details== * '''Requires''': {{vbzcart/table|stk_items}}, {{vbzcart/table|cat_items}} * '''Used by''': ==SQL== <section begin=sql /><mysql>CREATE OR REPLACE VIEW qryStk_lines_Title_info A...)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Details

  • Requires:
  1. REDIRECT Template:l/vc/table, cat_items
  • Used by:

SQL

<mysql>CREATE OR REPLACE VIEW qryStk_lines_Title_info AS SELECT 

 s.*,
 i.ID_Title

FROM stk_items AS s LEFT JOIN cat_items AS i ON s.ID_Item=i.ID;</mysql>

Retrieved from "https://htyp.org/mw/index.php?title=VbzCart/queries/qryStk_lines_Title_info&oldid=10952"