List:General Discussion« Previous MessageNext Message »
From:Jerry Schwartz Date:January 22 2010 6:04pm
Subject:RE: Join Suddenly Failing
View as plain text  
>-----Original Message-----
>From: Albert Padley [mailto:ap3design@stripped]
>Sent: Friday, January 22, 2010 12:37 PM
>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
[JS] Try making those JOINs explicit, I do believe they are treated 
differently in recent versions.


Regards,

Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032

860.674.8796 / FAX: 860.674.8341

www.the-infoshop.com






Thread
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