VbzCart/procs/Upd Titles fr TitleIttyps

About

 * Purpose: Updates some fields in
 * Input:, grouped by ID_Title
 * Output: (update)
 * History:
 * 2010-11-10
 * Added DROP PROCEDURE for easier maintenance.
 * Created in database (procs were not ported from L48 to Rizzo).
 * 2011-12-24 this was in a recursive loop: this&rarr;&rarr;&rarr;&rarr;this, so changed source from to.

SQL
DROP PROCEDURE IF EXISTS Upd_Titles_fr_TitleIttyps; CREATE PROCEDURE Upd_Titles_fr_TitleIttyps UPDATE _titles AS t LEFT JOIN (   SELECT      ID_Title,      SUM(ti.cntForSale) AS cntForSale,      SUM(ti.cntInPrint) AS cntInPrint,      SUM(ti.qtyForSale) AS qtyInStock     FROM qryCat_Titles_Item_stats AS ti GROUP BY ID_Title    ) AS ti ON ti.ID_Title=t.ID    SET t.cntForSale = ti.cntForSale, t.cntInPrint = ti.cntInPrint, t.qtyInStock = ti.qtyInStock;