VbzCart/docs/queries/qryStk lines Title info

From Woozle Writes Code
< VbzCart‎ | docs‎ | queries
Revision as of 02:23, 4 December 2008 by imported>Woozle (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

SQL

<section begin=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> <section end=sql />