Re: MySQL from Access
| From: | Jerry | Date: | Thu, 02 May 2002 16:51:34 +0000 |
| Subject: | Re: MySQL from Access | ||
| References: | 1 | Groups: | php.install |
| Request: | Send a blank email to php-install+get-6816@lists.php.net to get a copy of this message | ||
In article <20020502162204.87153.qmail@pb1.pair.com>,
chris.morrow@btopenworld.com (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/)