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

Reply via email to