Re: Using subselects as joins in POstgeSQL (possible?, examples) - Mailing list pgsql-sql

From	Pascual De Ruvo
Subject	Re: Using subselects as joins in POstgeSQL (possible?, examples)
Date	July 22, 2005 10:21:10
Msg-id	[email protected] Whole thread Raw
In response to	Using subselects as joins in POstgeSQL (possible?, examples) (frank church <[email protected]>)
List	pgsql-sql

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

From: KÖPFERL Robert
Date: 22 July 2005, 09:58:10
Subject: Re: Are long term never commited SELECT statements are a pr

From: Michael Fuhr
Date: 22 July 2005, 10:52:10
Subject: Re: Error when using array variable