VbzCart/docs/queries/qryStk lines Title info: Difference between revisions
Jump to navigation
Jump to search
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...) |
m (Woozle moved page VbzCart/VbzCart/queries/qryStk lines Title info to VbzCart/docs/queries/qryStk lines Title info without leaving a redirect: part 3/5) |
(No difference)
| |
Latest revision as of 01:56, 25 February 2024
Details
- Requires: Template:Vbzcart/table, Template:Vbzcart/table
- Used by:
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 />