Thread: SubQueries in FROM statement

SubQueries in FROM statement

From
Michael
Date:
I see that now the use of SubQueries are allowed in certain cases, but
is there any plans in the works to sllow subqueries in the FROM
statement.. ie

SELECT count(cats)
    FROM (
            SELECT name AS cats
                FROM animals
                WHERE species='feline'
            )



Re: [SQL] SubQueries in FROM statement

From
Vadim Mikheev
Date:
Michael wrote:
>
> I see that now the use of SubQueries are allowed in certain cases, but
> is there any plans in the works to sllow subqueries in the FROM
> statement.. ie
>
> SELECT count(cats)
>     FROM (
>             SELECT name AS cats
>                 FROM animals
>                 WHERE species='feline'
>             )

6.5 or 6.6... :(

Vadim