VbzCart/procs/Upd Titles fr TitleIttyps

From HTYP, the free directory anyone can edit

[edit] About

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

[edit] SQL

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;