» Ordering multiple SELECT statements in a UNION - Organize and share your code snippets

snippets | January 22, 2012

Ordering multiple SELECT statements in a UNION

(SELECT a FROM t1 WHERE a=10 AND B=1)
UNION
(SELECT a FROM t2 WHERE a=11 AND B=2)
ORDER BY a LIMIT 10;