>-Original Message-
>From: Albert Padley [mailto:ap3des...@gmail.com]
>Sent: Friday, January 22, 2010 12:37 PM
>To: mysql@lists.mysql.com
>Subject: Join Suddenly Failing
>
>I have a website that gets used once a year for a soccer tournament. It has
>been working fine since 2006. No script c
More precisely, you'll be better off always using explicit joins - that way
you not only prevent this, but also unexpected problems and the need to
review code when something happens to your DB schema.
On Fri, Jan 22, 2010 at 6:42 PM, Scott Swaim wrote:
> I ran into this when I upgraded from 4.
On Fri, January 22, 2010 09:42, Scott Swaim wrote:
> I ran into this when I upgraded from 4.0.xx to 5.0.xx There was a change
> in
> the logic for the Joins. I determined that the FROM clause needs to be in
> parenthesis. i.e.FROM (team, person, teamperson) this allows all of
> the
> fields
Scott,
Thanks. That appears to be the solution.
Albert
On Fri, Jan 22, 2010 at 10:42 AM, Scott Swaim wrote:
> I ran into this when I upgraded from 4.0.xx to 5.0.xx There was a change
> in
> the logic for the Joins. I determined that the FROM clause needs to be in
> parenthesis. i.e.FROM
I ran into this when I upgraded from 4.0.xx to 5.0.xx There was a change in
the logic for the Joins. I determined that the FROM clause needs to be in
parenthesis. i.e.FROM (team, person, teamperson) this allows all of the
fields in all of the tables to be used. The change was made in mysql
