Re: Merge 2 select statements ?

mhk schrieb:

> Hi,
>
> can anyone know how to merge two select statements into one
>
> Example :
>
> "select * from emp where location_id = 1"
> other is
> "select * from emp where location_id = 2"
>
> Now how can i merge these two with a single select statement. its a
> simple example but i am using a tough one in reality.
>
> Thanks
>
>
> Jeff
>

select * from emp where location_id in (1,2) Received on Thu Nov 27 2003 - 14:35:23 CST