syntax for UNION + ORDER BY

[Ivan Smahin]

Hello Christian,

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

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

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