Re: Help with a double left join

"Ari Nepon" <anepon(at)verveinternet(dot)com> writes:
> Thanks Alex. But it was too good to be true. Or, more likely, I did
> something else wrong.

clients.ID => client.ID, likely.

regression=# create table track(project int, client int);
CREATE
regression=# create table project(project_id int);
CREATE
regression=# create table client(ID int);
CREATE
regression=# select * from track LEFT JOIN project ON track.project=project.pro
ject_id
regression-# LEFT JOIN client ON track.client=clients.ID;
ERROR: Relation 'clients' does not exist
regression=# select * from track LEFT JOIN project ON track.project=project.pro
ject_id
regression-# LEFT JOIN client ON track.client=client.ID;
project | client | project_id | id
---------+--------+------------+----
(0 rows)

regards, tom lane