Difference between revisions of "VbzCart/queries/qryStk items remaining"
Jump to navigation
Jump to search
(post-move update; also name of underlying query changed) |
(another user) |
||
| Line 2: | Line 2: | ||
* '''Returns''': Same records as {{vbzcart/query|qryStk_lines_remaining}}, but grouped by Item | * '''Returns''': Same records as {{vbzcart/query|qryStk_lines_remaining}}, but grouped by Item | ||
* '''Requires''': {{vbzcart/query|qryStk_lines_remaining}} | * '''Requires''': {{vbzcart/query|qryStk_lines_remaining}} | ||
| − | * '''Used by''': {{vbzcart/query|qryCat_Items_Stock}} | + | * '''Used by''': {{vbzcart/query|qryCat_Items_Stock}}, {{vbzcart|proc|Upd_TitleIttyps_fr_CatItems_Titles}} |
* '''History''': | * '''History''': | ||
** '''2009-11-29''' Renamed from '''v_stk_items_remaining''' to '''qryStk_items_remaining'''; also underlying query renamed | ** '''2009-11-29''' Renamed from '''v_stk_items_remaining''' to '''qryStk_items_remaining'''; also underlying query renamed | ||
Latest revision as of 01:55, 24 January 2011
Details
- Returns: Same records as
- REDIRECT Template:l/vc/query, but grouped by Item
- Requires: qryStk_lines_remaining
- Used by: qryCat_Items_Stock, Upd_TitleIttyps_fr_CatItems_Titles
- 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>