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?
Senior Web Architect
pgsql-sql by date
|Next:||From: Tom Lane||Date: 2000-11-30 00:42:53|
|Subject: Re: [SQL] Rules with Conditions: Bug, or Misunderstanding |
|Previous:||From: Joel Burton||Date: 2000-11-30 00:07:57|
|Subject: Re: Cache look up failure|