Mysql更新多表查询

Question

我有3个表的select JOIN语句，我想知道UPDATE语句应该是什么。

SELECT candidates.CandidateName, candidates.CandidateVotes, candidates.Party, mainrace.MainRaceName, race.RaceName, candidates.win, candidates.NameOrder
FROM candidates
JOIN race ON race.RaceID = candidates.RaceID
JOIN mainrace ON mainrace.MainID = candidates.MainID
ORDER BY mainrace.MainRaceName'

我有这样的东西，我猜它是一团糟:)

$sql = "update candidates set candidates.CandidateName='$CandidateName',candidates.CandidateVotes='$CandidateVotes',candidates.Party='$Party',candidates.win='$win' ,candidates.NameOrder='$NameOrder' where candidates.CandidateID=$CandidateID"; 

感谢您的时间和帮助。

由衷地

Answer 1

语法应为：

Update  candidates join ... set