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