VbzCart/procs/Upd Titles fr TitleIttyps

About

• Purpose: Updates some fields in _titles
• Input: _title_ittyps, grouped by ID_Title
• Output: _titles (update)

SQL

<mysql>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.qtyInStock) AS qtyInStock
    FROM _title_ittyps 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;</mysql>