join question

From: 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?

« previous php.general (#323189) next »