Thread
:
Union Query
View Single Post
#
4
(
permalink
)
02-29-2008, 08:10 AM
David Portas
Posts: n/a
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
--
David Portas