php - 在单个查询中使用多个 JOINS 进行更新

Question

我正在尝试在一个查询中加入 4 个表，它可以编译，但没有返回或设置任何值。以下是我写的查询。一点帮助请

UPDATE tbl_venue_charges AS VC
  JOIN tbl_usr_training_master AS TM ON TM.trai_master_id = VC.vnu_chrg_id
  JOIN tbl_trainer_participant_expenses AS TPE ON TPE.trpex_id = VC.vnu_chrg_id
  JOIN tbl_usr_training_master2 AS UTM ON UTM.trai_master2_id = VC.vnu_chrg_id
  JOIN tbl_travelling_expenses AS TEX ON TEX.trv_exp_id = VC.vnu_chrg_id

  SET VC.trai_master_id = TM.trai_master_id AND
      VC.trpex_id = TPE.trpex_id,
      VC.trai_master2_id = UTM.trai_master2_id,
      VC.trv_exp_id = TEX.trv_exp_id;

标签： phpmysqldbforge