Thread: Union Query
View Single Post

   
  #4 (permalink)  
Old 02-29-2008, 08:10 AM
David Portas
 
Posts: n/a
Default Re: Union Query

SELECT a,b
FROM
(SELECT a, b, 1 AS ord
FROM mtTable
WHERE a = c
UNION
SELECT a, b, 2
FROM mtTable
WHERE a = c
AND ab = x) AS T
ORDER BY ord

--
David Portas
SQL Server MVP
--


Reply With Quote