syntax for UNION + ORDER BY

Wed Sep 19 07:39:43 CDT 2007

Le 19 sept. 07 à 09:10, Ivan Smahin a écrit :

> Hello Christian,
Hi Ivan,
>
> Wednesday, September 19, 2007, 2:25:00 AM, you wrote:
>
>> hi,
>
>
>> How can I mixe UNION and ORDER BY with valentina ???
>> I have a crash when I add my ORDER BY after the request
>
> Certainly it should not be a crash. Please show up your query.
>
> SELECT * FROM t1
> UNION
> SELECT * FROM t2
> ORDER BY f1

and "(" and ")"

in your example, you make "()" and I have a crash with this....

(SELECT * FROM t1)
UNION
(SELECT * FROM t2)
ORDER BY f1

crash (director and vs)

>
> So "Order by" will sort resulting table by field f1.

br
Christian
>
> -- 
> Best regards,
> Ivan Smahin
> Senior Software Engineer
> Paradigma Software, Inc
> Valentina - The Ultra-Fast Database
> http://www.valentina-db.com
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina