syntax for UNION + ORDER BY

Wed Sep 19 08:38:31 CDT 2007

Le 19 sept. 07 à 15:12, Ivan Smahin a écrit :

> Hello Christian,
Ivan,
>
> Wednesday, September 19, 2007, 3:39:43 PM, you wrote:
>
>>>
>>> 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)
>
> Indeed. Put it to the Mantis please.
> BTW - I don't see any reason to use brackets here.

"()" are in your examples :

http://www.valentina-db.com/dokuwiki/doku.php? 
id=paradigma:public:en:documentation:vsql:reference:select:union_interse 
ct_difference_except

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