Difference between revisions of "VbzCart/queries/qryStk lines Title info"
Jump to navigation
Jump to search
(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...) |
(No difference)
|
Latest revision as of 02:23, 4 December 2008
Details
- Requires:
- 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>