Re: Sv: [SQL] how to build this query ??? Please help !!!

[Tom Lane]

Tod McQuillin <[EMAIL PROTECTED]> writes:
> I don't think the PostgreSQL User's Manual mentions sub-selects.

I think you are right :-(.  Geez, that's a pretty big hole in the
docs coverage.

There is some stuff in the Tutorial --- see
http://www.postgresql.org/devel-corner/docs/postgres/sql-language.htm#SELECT
and page down to "Subqueries".  Note that the subquery-in-FROM feature
is new in 7.1.

                        regards, tom lane