Avoiding UNIONS

[srinivasang87]

Hi,
I have a query with three select statements joined using two UNION's.
All three queries differ ONLY in the where condition.

It goes something like this:

select
    Emp_No,
    Emp_Name,
    Salary
from
    Employee
where
    Band = "A"
union
select
    Emp_No,
    Emp_Name,
    Salary
from
    Employee
where
    Band = "B"
union
select
    Emp_No,
    Emp_Name,
    Salary
from
    Employee
where
    Band = "C"

Is there a way to combine these queries?

[mabubakarpk]

sure, you can also write this query

select
    Emp_No,
    Emp_Name,
    Salary
from
    Employee
where
    Band  in ('A','B','C')
 

[pkreemer]

Or, maybe just a tiny bit faster, but more verbose:

SELECT
    Emp_No,
    Emp_Name,
    Salary
FROM
    Employee
WHERE
    Band='A' OR Band='B' OR Band='C'
 

But the IN statement is so handy.