Thread

1. SubQueries in FROM statement

   Michael <wwwadmin@wizard.ca> — 1998-07-27T05:56:13Z

   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'
               )
   
   
   
   

2. Re: [SQL] SubQueries in FROM statement

   Vadim Mikheev <vadim@krs.ru> — 1998-07-27T06:14:22Z

   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