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(at)gmx(dot)net