Select clause in JOIN statement - Mailing list pgsql-sql

From JORGE MALDONADO
Subject Select clause in JOIN statement
Date
Msg-id CAAY=A7-8U-AP_Y4wwe_KzN2=0yJBBDt9NOWNceG+FFASxvFGgw@mail.gmail.com
Whole thread Raw
Responses Re: Select clause in JOIN statement
List pgsql-sql
<div dir="ltr">Is it valid to specify a SELECT statement as part of a JOIN clause?<div style="style"><br /></div><div
style="style">Forexample:</div><div style="style"><br /></div><div style="style">SELECT table1.f1, table1.f2 FROM
table1</div><divstyle="style">INNER JOIN </div><div style="style">(SELECT table2.f1, table2.f2 FROM table2) table_aux
ONtable1.f1 = table_aux.f1</div><div style="style"><br /></div><div style="style">Respectfully,<br /></div><div
style="style">JorgeMaldonado</div></div> 

pgsql-sql by date:

Previous
From: rawi
Date:
Subject: Re: Index Usage and Running Times by FullTextSearch with prefix matching
Next
From: Luca Vernini
Date:
Subject: Re: Select clause in JOIN statement