Difference between revisions of "VbzCart/queries/qryStk items remaining"
Jump to navigation
Jump to search
m (moved VbzCart/queries/v stk items remaining to VbzCart/queries/qryStk items remaining: time to rebuild this one too...) |
(post-move update; also name of underlying query changed) |
||
Line 1: | Line 1: | ||
==Details== | ==Details== | ||
− | * '''Returns''': Same records as {{vbzcart/query| | + | * '''Returns''': Same records as {{vbzcart/query|qryStk_lines_remaining}}, but grouped by Item |
− | * '''Requires''': {{vbzcart/query| | + | * '''Requires''': {{vbzcart/query|qryStk_lines_remaining}} |
− | * '''Used by''': | + | * '''Used by''': {{vbzcart/query|qryCat_Items_Stock}} |
+ | * '''History''': | ||
+ | ** '''2009-11-29''' Renamed from '''v_stk_items_remaining''' to '''qryStk_items_remaining'''; also underlying query renamed | ||
==SQL== | ==SQL== | ||
− | <section begin=sql /><mysql>CREATE OR REPLACE VIEW | + | <section begin=sql /><mysql>CREATE OR REPLACE VIEW qryStk_items_remaining AS |
SELECT | SELECT | ||
ID_Item, | ID_Item, | ||
Line 10: | Line 12: | ||
SUM(QtyForShip) AS QtyForShip, | SUM(QtyForShip) AS QtyForShip, | ||
SUM(QtyExisting) AS QtyExisting | SUM(QtyExisting) AS QtyExisting | ||
− | FROM | + | FROM qryStk_lines_remaining |
GROUP BY ID_Item;</mysql> | GROUP BY ID_Item;</mysql> | ||
<section end=sql /> | <section end=sql /> |
Revision as of 23:21, 29 November 2009
Details
- Returns: Same records as
- REDIRECT Template:l/vc/query, but grouped by Item
- Requires: qryStk_lines_remaining
- Used by: qryCat_Items_Stock
- History:
- 2009-11-29 Renamed from v_stk_items_remaining to qryStk_items_remaining; also underlying query renamed
SQL
<mysql>CREATE OR REPLACE VIEW qryStk_items_remaining AS
SELECT ID_Item, SUM(QtyForSale) AS QtyForSale, SUM(QtyForShip) AS QtyForShip, SUM(QtyExisting) AS QtyExisting FROM qryStk_lines_remaining GROUP BY ID_Item;</mysql>