converting SQL code from MS Access to MySQL code

lukman · #1 (**permalink**) 01-27-04, 16:31

How do i convert SQL code from MS Access to MySQL code

aus · #2 (**permalink**) 01-27-04, 18:21

I don't know of an automatic way of doing it. You will definitely have to change the table join syntax. i.e. None of this:

Code:

SELECT * FROM table1 INNER JOIN (table2 INNER JOIN table3 ON table2.id = table3.parentid) ON table1.id = table2.parentid;

This would be rewritten as:

Code:

SELECT * FROM table1
INNER JOIN table2 ON table1.id = table2.parentid
INNER JOIN table3 ON table2.id = table3.parentid;