VbzCart/procs/Upd Titles fr TitleIttyps
from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
About
- Purpose: Updates some fields in _titles
- Input: _title_ittyps, grouped by ID_Title
- Output: _titles (update)
SQL
<section begin=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>
<section end=sql />
