Postgres Pro
Downloads
Home   >   mailing lists

Re: self outer join - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: self outer join
Date
Msg-id Pine.LNX.4.30.0111070104560.3607-100000@peter.localdomain
Whole thread Raw
In response to self outer join  (David Link <dlink@soundscan.com>)
List pgsql-general
Tree view 
David Link writes:

> How does one specify an alias for the table being joined.

select * from t1 as a left outer join t1 as b using (a.col1 = b.col2);

--
Peter Eisentraut   peter_e@gmx.net

pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: Creating tables from files
Next
From: Jason Earl
Date:
Subject: Re: Creating tables from files