MySQL from Access
| From: | News | 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