Re: join question

On 4/13/2014 2:50 PM, richard gray wrote:

On 13/04/2014 20:21, Jim Giner wrote:

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?

I think the join statements should be before the assignment i.e. $q = "update leaders as m

         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
     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";

Interesting. Didn't think of that work-around. I'll try it! Of course, the Masters is over for this year so it'll probably be on the back burner for 11 months!