SEO

#1 (**permalink**) 02-29-2008, 08:08 AM

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

#2 (**permalink**) 02-29-2008, 08:08 AM

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

#3 (**permalink**) 02-29-2008, 08:09 AM

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?

#4 (**permalink**) 02-29-2008, 08:10 AM

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

#5 (**permalink**) 02-29-2008, 08:12 AM

Thanks David.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Union Query