On 7/22/05, frank church <pgsql(at)adontendev(dot)net> wrote:> > > > Is it possible to use subselects as joins in PostgreSQL.
Absolutely.
select * from (select * from table1) as a, (select * from table2) as b where a.a = b.b