VbzCart/docs/queries/v stk titles remaining: Difference between revisions
Jump to navigation
Jump to search
imported>Woozle (New page: ==Details== * '''Returns''': Same records as {{vbzcart/query|v_stk_lines_remaining}}, but grouped by Title * '''Requires''': {{vbzcart/query|v_stk_lines_remaining}}, {{vbzcart/query|cat_it...) |
m (Woozle moved page VbzCart/VbzCart/queries/v stk titles remaining to VbzCart/docs/queries/v stk titles remaining without leaving a redirect: part 3/5) |
(No difference)
| |
Latest revision as of 01:56, 25 February 2024
Details
- Returns: Same records as Template:Vbzcart/query, but grouped by Title
- Requires: Template:Vbzcart/query, Template:Vbzcart/query
- Used by:
SQL
<section begin=sql /><mysql>CREATE OR REPLACE VIEW v_stk_titles_remaining AS
SELECT ID_Title, SUM(QtyForSale) AS QtyForSale, SUM(QtyForShip) AS QtyForShip, SUM(QtyExisting) AS QtyExisting FROM v_stk_lines_remaining AS s LEFT JOIN cat_items AS i ON s.ID_Item=i.ID GROUP BY i.ID_Title;</mysql>
<section end=sql />