"Darryl M. Wolski" <drwolski@sympatico.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