Received: from sss.pgh.pa.us ([192.204.191.242]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f5MFFEa31860 for ; Fri, 22 Jun 2001 11:15:14 -0400 (EDT) (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 f5MFF9303978; Fri, 22 Jun 2001 11:15:09 -0400 (EDT) To: anepon@verveinternet.com cc: "Pgsql-Sql" Subject: Re: Help with a double left join In-reply-to: References: Comments: In-reply-to "Ari Nepon" message dated "Fri, 22 Jun 2001 09:43:58 -0400" Date: Fri, 22 Jun 2001 11:15:08 -0400 Message-ID: <3975.993222908@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200106/371 X-Sequence-Number: 3661 "Ari Nepon" 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