MySQL from Access

From: Date: Thu, 02 May 2002 16:22:22 +0000
Subject: MySQL from Access
Groups: php.install 
Request: Send a blank email to php-install+get-6815@lists.php.net to get a copy of this message
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

« previous php.install (#6815) next »