Re: nested inner join help

"Darryl M. Wolski" <drwolski(at)sympatico(dot)ca> 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