Union Query

hi,

Can you union 2 queries with an IF statement between them?

e.g.

select a, b
from mtTable
where a = c

union

if ab = x
begin

select a, b
from mtTable
where a = c

end

Cheers,
Jack

Not exactly. But you could put the extra condition in a WHERE clause. I'm
not clear what AB is in your example but any expression that can go after
your IF statement will be valid in the WHERE clause.

SELECT a, b
FROM mtTable
WHERE a = c
UNION
SELECT a, b
FROM mtTable
WHERE a = c
AND ab = x

--
David Portas
SQL Server MVP
--

Thanks - worked perfectly!

You don't know how I can keep the order in between queries? (order by)

Do I have to use a sub-query for each select statement?

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

Thanks David.