Postgres Pro
Downloads
Home   >   mailing lists

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
Msg-id fb73c1ee050722062173228831@mail.gmail.com
Whole thread Raw
In response to Using subselects as joins in POstgeSQL (possible?, examples)  (frank church <pgsql@adontendev.net>)
List pgsql-sql
Tree view


On 7/22/05, frank church <pgsql@adontendev.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




pgsql-sql by date:

Previous
From: KÖPFERL Robert
Date:
Subject: Re: Are long term never commited SELECT statements are a pr
Next
From: Michael Fuhr
Date:
Subject: Re: Error when using array variable