Hi Guys! I am having trouble after upgrading a database application from Access to MySQL.
My whole site runs fine except for one SQL query which works fine in Access but for some reason MySQL doesn't like it at all. Is there a big difference between the way Access and MySQL implement SQL? Here is the query..... SELECT Periode.LibPeriode, PaysPeriode.RefPaysPeriode, PaysPeriode.DateDebut, PaysPeriode.DateFin FROM Periode INNER JOIN (Pays INNER JOIN PaysPeriode ON Pays.RefPays = PaysPeriode.RefPays) ON Periode.RefPeriode = PaysPeriode.RefPeriode ORDER BY Periode.libPeriode, PaysPeriode.DateDebut This has got my really confused as like I said it work fine in Access. Can anybody help? Please? Thanks, Chris -- PHP Install Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php