[INFO] Working subquery types

[Ruslan Zasukhin]

On 9/6/04 8:38 PM, "Ivan Smahin" <IvanSmahin at public.kherson.ua> wrote:

> Hello All,
> 
> //***********************************************************************
> // SUBQUERIES in where clause
> //


> //***********************************************************************
> // SUBQUERIES in from clause
> //
> // ATTENTION:
> //           This is absolutely legal following standard, but it does not work
> //           on MS-SQL.
> //
> 
> 7.
>   // select ... from (subquery)
> 
>   Example:
>   select PERSONID from (select * from Students)
> 
> 8.
>   // select ... from (subquery) where ...
> 
>   Example:
>   select PERSONID from (select * from Students) where personID = 2

Ivan,

It seems you have told also about subq in the SELECT clause ?



-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------