syntax for UNION + ORDER BY

Ivan Smahin ivan_smahin at paradigmasoft.com
Wed Sep 19 08:12:41 CDT 2007


Hello Christian,

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.

-- 
Best regards,
Ivan Smahin 
Senior Software Engineer
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
http://www.valentina-db.com



More information about the Valentina mailing list