join question
| From: | Jim Giner | Date: | Sun, 13 Apr 2014 18:21:39 +0000 |
| Subject: | join question | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-323189@lists.php.net to get a copy of this message | ||
Trying to do a quick Masters analysis and having trouble with a complex join
$q = "update leaders as m set Score1=a.score,
Score2=b.score,
Score3=c.score,
Score4=d.score,
Score5=e.score,
Score6=f.score,
Score7=g.score,
Score8=h.score,
Score9=i.score,
Score10=j.score,
Score11=k.score,
Score12=l.score
left outer join golfers a on a.golfer = m.Player1
left outer join golfers b on b.golfer = m.Player2
left outer join golfers c on c.golfer = m.Player3
left outer join golfers d on d.golfer = m.Player4
left outer join golfers e on e.golfer = m.Player5
left outer join golfers f on f.golfer = m.Player6
left outer join golfers g on g.golfer = m.Player7
left outer join golfers h on h.golfer = m.Player8
left outer join golfers i on i.golfer = m.Player9
left outer join golfers j on j.golfer = m.Player10
left outer join golfers k on k.golfer = m.Player11
left outer join golfers l on l.golfer = m.Player12";
Keeps telling me:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'left outer join golfers a on a.golfer = m.Player1 left outer join golfers b on' at line 2'
Anyone?