Ordering multiple SELECT statements in a UNION - SQL Snipplr Social Repository

Revision: 4202

at November 6, 2007 08:43 by andyhartleeds

Initial Code

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

Initial URL

Initial Description

Initial Title

Ordering multiple SELECT statements in a UNION

Initial Tags

mysql, database, sql, order

Initial Language

SQL