Subselect in join?

From: "Kenn Thompson" <kthompson(at)adestagroup(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Subselect in join?
Date: 2000-11-30 00:24:39
Message-ID: sa2549f7.059@10.0.0.4
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Ok- Seems I've seen this somewhere, but can't seem to get it to work. Is my memory flawed, or is this just not an implemented feature?

SELECT * FROM (SELECT foo, bar FROM tfoobar)

In english- is it not possible to to a subselect in a FROM clause?

Kenn

____________________________________________
Kenn Thompson
Senior Web Architect
Adesta Communications
Work: 402.233.7595
Cell: 402.210.6326

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2000-11-30 00:42:53 Re: [SQL] Rules with Conditions: Bug, or Misunderstanding
Previous Message Joel Burton 2000-11-30 00:07:57 Re: Cache look up failure