VbzCart/docs/procs/Upd DeptIttyps fr CatIttyps

About

• Input: Template:Vbzcart
• Output: Template:Vbzcart (update)

SQL

<section begin=sql /><mysql>CREATE PROCEDURE Upd_DeptIttyps_fr_CatIttyps()

 UPDATE _dept_ittyps AS di LEFT JOIN cat_ittyps AS it ON it.ID=di.ID_ItTyp
   SET
     di.ItTypNameSng = it.NameSng,
     di.ItTypNamePlr = IFNULL(it.NamePlr,it.NameSng);</mysql>

<section end=sql />