In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] (News) wrote: > 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
I am far from an expert in SQL, but I don't think I've seen a MySQL statement that uses parentheses to separate JOINs. I suspect what you want is: SELECT Periode.LibPeriode, PaysPeriode.RefPaysPeriode, PaysPeriode.DateDebut, PaysPeriode.DateFin FROM Pays INNER JOIN PaysPeriode ON Pays.RefPays=PaysPeriode.RefPays INNER JOIN Periode ON PaysPeriode.RefPeriode=Periode.RefPeriode ODER BY Periode.libPeriode, PaysPeriode.DateDebut Jerry -- http://www.hoboes.com/jerry/ "Give a man a fish and you feed him for a day. Teach him to fish, and you've depleted the lake."--It Isn't Murder If They're Yankees (http://www.hoboes.com/jerry/Murder/) -- PHP Install Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
