VbzCart/queries/qryStk items remaining

Details

 * Returns: Same records as, but grouped by Item
 * Requires:
 * Used by: ,
 * History:
 * 2009-11-29 Renamed from v_stk_items_remaining to qryStk_items_remaining; also underlying query renamed

SQL
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;