CREATE PROCEDURE Upd_TitleIttyps_fr_Titles() UPDATE _title_ittyps AS ti LEFT JOIN _titles AS t ON t.ID=ti.ID_Title SET ti.CatNum = t.CatNum, ti.CatWeb = t.CatWeb;