2 Order By's with 3 unions

PolarBear2k · #1 (**permalink**) 11-25-05, 16:45

Hi,

I have a query with 3 unions and I want to order the first two unions using one ORDER BY and the last union with a different ORDER BY. Unfortunately I am unable to group the first two selects with the first ORDER BY with parentheses without getting an error.

ex:

(SELECT a,b FROM table1)
UNION
(SELECT c,d FROM table2)
ORDER BY a,d
UNION
SELECT x,y FROM table3
ORDER BY y

Thanks

jfulton · #2 (**permalink**) 11-25-05, 17:29

Try this. You need the "LIMIT" statement in there.

Code:

(
   SELECT * 
   FROM
   (
      (SELECT a,b FROM table1)
      UNION
      (SELECT c,d FROM table2)
   ) AS blah
   ORDER BY a,d
   LIMIT n
)
UNION ALL
(
   SELECT x,y FROM table3
   ORDER BY y
   LIMIT n
)

Internet Services

Web Development

Digital Marketing

Consumer Tech