Case Statement in WHERE clause

[edwinjs]

Hi

I am not able to execute the following query.

select emp_code from employees
where emp_code in (case when emp_type = 1 then
select emp_code from table1
else
select emp_code from table2
end)

when i execute the above query, I am getting the following error.

ORA-01427 single-row subquery return more than one row

Regards

Edwin

[debasisdas]

ORA-01427 single-row subquery return more than one row

The error message itself is self explanatory.

[edwinjs]

yeah i know. but IN operator can accept multiple values.