Received: from sss.pgh.pa.us ([192.204.191.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g0ELbQV08173 for ; Mon, 14 Jan 2002 16:37:26 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.4/8.11.4) with ESMTP id g0ELbQg19357; Mon, 14 Jan 2002 16:37:27 -0500 (EST) To: "Darryl M. Wolski" cc: pgsql-sql@postgresql.org Subject: Re: nested inner join help In-reply-to: <000801c1973d$75ea1980$ae00a8c0@arbour> References: <000801c1973d$75ea1980$ae00a8c0@arbour> Comments: In-reply-to "Darryl M. Wolski" message dated "Mon, 07 Jan 2002 00:37:56 -0500" Date: Mon, 14 Jan 2002 16:37:26 -0500 Message-ID: <19354.1011044246@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200201/149 X-Sequence-Number: 6235 "Darryl M. Wolski" writes: > 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)); Looks fine to me. Are you using an old Postgres version? We didn't support JOIN keywords until 7.1. regards, tom lane