SQL Syntax Compatibility

[imstillatwork]

I want to move from access to MySQL....

Most of my querys are rather simple, I do have a few multiple table outer joins.. will i need to make any changes to my SQL to work with MySQL?

What about ACCESS to MSSQL??

thank!

 

[cwong1]

Hello.

I think if your SQL statements are really simple, you don't need to change it anymore. However, there are certain things that you should remember, such as MySQL does not provide sub-queries... there are also some joins that don't work on the older vesions of MySQL.

Hope it helps.