Using mysql query causes error (1 Viewer)

[geoB]

I'm using Access to develop reports on a MySQL database. My first step has been to get the query right using MySQL's Query Browser. On occasion, a copy and paste of the SQL statement will generate an error in Access. Can you recommend a good resource for understanding the differences between Access & MySQL and their allowable SQL statement syntax?

Thanks.

George

 

[jdraw]

I don't know what you have tried. I see you have made 61 posts on this forum, so my guess is you know how to Google many things.

This link will tell you the MySQL 5.0 SQL commands.
http://dev.mysql.com/doc/refman/5.0/en/sql-syntax.html

These links will deal with MSAccess SQL
http://msdn.microsoft.com/en-us/library/aa140011(office.10).aspx
http://msdn.microsoft.com/en-us/library/aa140015(office.10).aspx
http://msdn.microsoft.com/en-us/library/aa139977(office.10).aspx

Have you tried linking the MySQL tables in Access and then use Access frontend -- queries, reports etc.

It isn't clear if you have expertise in Access and less in MySQL or vice versa.

 

[geoB]

It isn't clear if you have expertise in Access and less in MySQL or vice versa.

About the same in both, and I consider myself above average in each. I've developed apps in Access on contract as well as websites using PHP and MySQL.

I was just puzzled by the error I got in Access after pasting in a statement that worked nicely in MySQL. So clearly they are not equivalent. I'm not looking to track down the specific error; I can get the result I want by designing a query in Access. Instead, all I'd like to know is if there is a document or other resource well known to others that compares the two SQLs. It's not a big enough priority to wade through the gazillion Google results.

g

 

[geoB]

fwiw, the error I encountered was due to the Access requirement of parentheses in a complex set of JOIN statements. Hardly optimal and precludes copy & paste from MySQL for similar queries.

g