Received: from tomts20-srv.bellnexxia.net (tomts20.bellnexxia.net [209.226.175.74]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g075c1m83936 for ; Mon, 7 Jan 2002 00:38:02 -0500 (EST) (envelope-from drwolski@sympatico.ca) Received: from arbour ([64.229.28.239]) by tomts20-srv.bellnexxia.net (InterMail vM.4.01.03.16 201-229-121-116-20010115) with SMTP id <20020107053802.YBVO9253.tomts20-srv.bellnexxia.net@arbour> for ; Mon, 7 Jan 2002 00:38:02 -0500 Message-ID: <000801c1973d$75ea1980$ae00a8c0@arbour> From: "Darryl M. Wolski" To: Subject: nested inner join help Date: Mon, 7 Jan 2002 00:37:56 -0500 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0005_01C19713.8CAC27F0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2919.6700 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700 X-Archive-Number: 200201/130 X-Sequence-Number: 6218 This is a multi-part message in MIME format. ------=_NextPart_000_0005_01C19713.8CAC27F0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I have a query which works perfectly fine in mysql but won't work in the same database in postgres... Can anyone take a look at this and tell me what the problem is? I get a parser error at (. SELECT orderlines.quantity, products.productname, products.productcost, cus= tomers.custlname,customers.custfname FROM (((orders INNER JOIN orderlines ON orders.orderid =3D orderlines.lnkor= derid) INNER JOIN customers ON (customers.custid =3D orders.lnkcustid)) IN= NER JOIN products ON (products.productid =3D orderlines.lnkproductid)) WHERE (((orders.orderid)=3D2)); It seems as soon as I try to nest an INNER JOIN I get these parser errors. = I have tried this query a few different ways, and still cant get it to work. Thank you so much!! Darryl Wolski ------=_NextPart_000_0005_01C19713.8CAC27F0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
I  have a query which works perfectly= fine in=20 mysql but won't
work in the same database in=20 postgres...
 
Can anyone take a look at this and tell me= what the=20 problem is?
 
I get a parser error at (.
 
SELECT orderlines.quantity, products.produ= ctname,=20 products.productcost, customers.custlname,customers.custfname
FROM (((or= ders=20 INNER JOIN orderlines ON orders.orderid =3D orderlines.lnkorderid)  IN= NER=20 JOIN customers ON (customers.custid =3D orders.lnkcustid)) INNER JOIN produ= cts ON=20 (products.productid =3D orderlines.lnkproductid))
WHERE=20 (((orders.orderid)=3D2));
It seems as soon as I try to nest an INNER= JOIN I=20 get these parser errors. I have tried this query a few different ways, and = still=20 cant get it to work.
 
Thank you so much!!
 
Darryl Wolski
------=_NextPart_000_0005_01C19713.8CAC27F0--