List:General Discussion« Previous MessageNext Message »
From:Wm Mussatto Date:January 22 2010 5:48pm
Subject:RE: Join Suddenly Failing
View as plain text  
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 in all of the tables to be used.  The change was made in mysql so
> that only the last table (i.e. teamperson) was used for your JOIN
> Scott Swaim
> I.T. Director
> Total Care / Joshua Family Medical Care
> (817) 297-4455
> Website:
Actually the change happened half way through the 4.x series. Basically
you need to tell mySql which table you wish to join on.  Parentheses is
one way to say check all.
> NOTICE: The information contained in this e-mail is privileged and
> confidential and is intended for the exclusive use of the recipient(s)
> named
> above. If you are not the intended recipient or his or her agent, you are
> hereby notified that you have received this document in error and that any
> use, disclosure, dissemination, distribution, or copying of this message
> is
> prohibited. If you have received this communication in error, please
> notify
> the sender immediately by e-mail, and delete the original message
> -----Original Message-----
> From: Albert Padley [mailto:ap3design@stripped]
> Sent: Friday, January 22, 2010 11:37 AM
> To: mysql@stripped
> 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 changes since it was last used in
> 2009. All of a sudden the following script started throwing an error.
> SELECT contactinfo.contactdata, contactinfo.ContactID FROM team, person,
> teamperson
> LEFT JOIN personcontact ON person.PersonID = personcontact.PersonID
> LEFT JOIN contactinfo ON personcontact.ContactID = contactinfo.ContactID
> WHERE team.teamID = 22
> AND team.TeamID = teamperson.TeamID
> AND teamperson.PersonID = person.PersonID
> AND person.PeopleTypeID =5
> AND contactinfo.ContactTypeID =2
> Error: Unknown column 'person.PersonID' in 'on clause' (1054)
> There are several of these type scripts and all are giving a similar
> error.
> The server version is 5.0.87. I suspect the hosting company may have
> upgraded to a new version of mysql.
> Thanks.
> Albert
William R. Mussatto
Systems Engineer

Join Suddenly FailingAlbert Padley22 Jan
  • RE: Join Suddenly FailingScott Swaim22 Jan
    • Re: Join Suddenly FailingAlbert Padley22 Jan
    • RE: Join Suddenly FailingWm Mussatto22 Jan
    • Re: Join Suddenly FailingJohan De Meersman22 Jan
  • RE: Join Suddenly FailingJerry Schwartz22 Jan