It works. Also consider views. Just used this on a my db:
SELECT * FROM tblcus_customer INNER JOIN ( SELECT * FROM tblcus_customer_status WHERE status_id > 0) AS b ON tblcus_customer.status = b.status_id You can even join with a function result. Regards, Luca. 2013/6/14 JORGE MALDONADO <jorgemal1...@gmail.com>: > 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 -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql