Re: self outer join

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