>-----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 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
