Select clause in JOIN statement

JORGE MALDONADO <jorgemal1960@gmail.com>

From: JORGE MALDONADO <jorgemal1960@gmail.com>
To: pgsql-sql@postgresql.org
Date: 2013-06-13T22:40:36Z
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