Select clause in JOIN statement

From: JORGE MALDONADO <jorgemal1960(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Select clause in JOIN statement
Date: 2013-06-13 22:40:36
Message-ID: CAAY=A7-8U-AP_Y4wwe_KzN2=0yJBBDt9NOWNceG+FFASxvFGgw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Is it valid to specify a SELECT statement as part of a JOIN clause?

For example:

SELECT table1.f1, table1.f2 FROM table1
INNER JOIN
(SELECT table2.f1, table2.f2 FROM table2) table_aux ON table1.f1 =
table_aux.f1

Respectfully,
Jorge Maldonado

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Luca Vernini 2013-06-13 23:10:51 Re: Select clause in JOIN statement
Previous Message rawi 2013-06-13 15:39:26 Re: Index Usage and Running Times by FullTextSearch with prefix matching