Request a Demo
Home   >   mailing lists

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
Responses Re: Select clause in JOIN statement
List pgsql-sql
Tree view
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

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