Re: [SQL] Using subselects as joins in POstgeSQL (possible?, examples)

[Pascual De Ruvo]

On 7/22/05, frank church <[EMAIL PROTECTED]> 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