"Ari Nepon" <[EMAIL PROTECTED]> 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
regres
2001 9:42 AM
To: Ari Nepon
Cc: Pgsql-Sql
Subject: Re: [SQL] Help with a double left join
On Wed, 20 Jun 2001, Ari Nepon wrote:
> I am trying to do a left join FROM [a table with two columns that have
> foreign IDs] LEFT JOIN [two other tables, each has a unique ID].
>
> I have the left
I am trying to do a left join FROM [a table with two columns that have
foreign IDs] LEFT JOIN [two other tables, each has a unique ID].
I have the left join working where I join only two tables (not three):
SELECT track.ID, track.employee, track.client, track.task,
track.description, track.hours
