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:
Category:Connector / ODBC Severity:S3 (Non-critical)
Version:3.51 OS:
Assigned to: CPU Architecture:Any

[9 Aug 2005 4:57] Raffi T K

I am using

	1.  MySql 3.23
	2.  Crystal Reports
	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:
[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


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


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.