ORDER BY

[Ivan Smahin]

Hello jda,

Saturday, August 7, 2004, 3:04:14 PM, you wrote:

>>  >> 1.
>>>>  SELECT f1, f2
>>>>  FROM T
>>>>  ORDER BY f3
>>  >>

j> Hi Ivan,

j> If f3 is a correct method that manipulates data retrieved from f1, 
j> does that throw an error, or does that work?

j> Jon
j> _______________________________________________
j> Valentina-beta mailing list
j> Valentina-beta at lists.macserve.net
j> http://lists.macserve.net/mailman/listinfo/valentina-beta

It does not matter what is field you are using.
Order By just checks that ordered name is from the select list.

Example:

select f1 as ff from Table Order By f1

Here is exception due to the SQL standard. Because no field with name f1 in the select list.
There is "ff" name.

-- 
Best regards,
 Ivan                            mailto:IvanSmahin at public.kherson.ua