Re: Merge 2 select statements ?

Thanks but ,

As i said earlier i need to merge two tough separate select statement in reality.

Please help me in merging this following select Statements

select ename, '3' As rate from emp where sal = 950;

other is

select ename, '1' As rate from emp where sal = 11950;

i Hope now its clear, as now u cannot use your previous statement.

Please help ,

Thanks

Jeff

Thomas Kellerer wrote:
>
>
> 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
>>