edwinjs
Last Activity: Oct 3 '07, 11:19 AM
Joined: Sep 25 '07
Location:
-
yeah i know. but IN operator can accept multiple values. -
Case Statement in WHERE clause
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...
No activity results to display
Leave a comment: