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

From: Pascual De Ruvo <deruvo(at)gmail(dot)com>
To: frank church <pgsql(at)adontendev(dot)net>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Using subselects as joins in POstgeSQL (possible?, examples)
Date: 2005-07-22 13:21:06
Message-ID: fb73c1ee050722062173228831@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Michael Fuhr 2005-07-22 13:51:56 Re: Error when using array variable
Previous Message KÖPFERL Robert 2005-07-22 12:57:52 Re: Are long term never commited SELECT statements are a pr