MySQL Forums
Forum List  »  Quality Assurance

Re: Query Error
Posted by: Thomas CORBIERE
Date: August 30, 2007 07:53AM

Hello,

According to the manual :

"Note that INNER JOIN syntax allows a join_condition only from MySQL 3.23.17 on. The same is true for JOIN and CROSS JOIN only as of MySQL 4.0.11."

So, I think this is because the version of MySQL you are using on the production version is too old for this syntax. You should write the join condition in the WHERE
clause instead.

SELECT sidekicknews_news.ID, sidekicknews_news.name, sidekicknews_news.mail, sidekicknews_news.title, sidekicknews_news.news, sidekicknews_news.timestamp, sidekicknews_news.kategorieID, sidekicknews_news.checked, sidekicknews_kategorie.id, sidekicknews_kategorie.name AS 'kategorie'
FROM sidekicknews_news, sidekicknews_kategorie
WHERE sidekicknews_news.kategorieID = sidekicknews_kategorie.id
AND sidekicknews_kategorie.name = 'Bongs'
ORDER BY timestamp DESC

Regards,

Thomas CORBIERE

Options: ReplyQuote


Subject
Views
Written By
Posted
4714
August 30, 2007 03:57AM
2589
August 30, 2007 04:42AM
2572
August 30, 2007 05:51AM
Re: Query Error
2537
August 30, 2007 07:53AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.