VbzCart/queries/v stk titles remaining

Details

 * Returns: Same records as, but grouped by Title
 * Requires: ,
 * Used by:

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