Bug #12451 ODBC error: [MySQL][ODBC 3.51 Driver] - Error in SQL syntax near INNER JOIN
Submitted: 9 Aug 2005 4:57 Modified: 21 Mar 2007 10:41
Reporter: Raffi T K Email Updates:
Status: Closed Impact on me:
None 
Category:Connector / ODBC Severity:S3 (Non-critical)
Version:3.51 OS:
Assigned to: CPU Architecture:Any

[9 Aug 2005 4:57] Raffi T K 
Description:
Hello....

I am using

	1.  MySql 3.23
	2.  Crystal Reports 8.0.1.0
	3.  MySQL ODBC 3.51 Driver

I am getting an error listed below... please help me....

ODBC error: [MySQL][ODBC 3.51 Driver][mysqld-3.23.49-nt]You hve an error 

in your SQL syntax near INNER JOIN INV_DB.site site1 ON 

tooleqpt.tlsEqptSite=site1.id} at line 1

How to repeat:
a
[21 Mar 2007 10:41] Tonci Grgin 
Thank you for your bug report. This issue has already been fixed in the latest released version of that product, which you can download at

  http://www.mysql.com/downloads/

Explanation:
Hi Raffi and thanks for your report. We appologize for the delay, somehow this report got neglected...

Please upgrade to MyODBC 3.51.14:
 - MySQL server 5.0.38BK on WinXP Pro SP2 localhost
 - MyODBC 3.51.14GA
 - CR 11.0.0.895

--Test--

SELECT distinct t1.Artikl, t2.Datum FROM iradobra AS t1 INNER JOIN ira AS t2 ON t1.Ira = t2.Ira AND t1.Godina = t2.Godina AND t1.Tip = t2.Tip
returning about 120000 rows with no problem.