Why subqueries in case are not working in teradata?

Visit Teradata.com

Home

Guidelines

Member List

Welcome Guest ( Login | Register )

This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.

Why subqueries in case are not working in...

Rate Topic

Display Mode

Topic Options

Author

Message

JACKSON

Posted 5/8/2008 9:18:40 AM

Forum Newbie

Group: Forum Members
Last Login: 5/8/2008 9:02:52 AM
Posts: 2, Visits: 4

Please look at the query below

select
ename
from
emp e
where
not exists(select
'x'
from
dept d
where
d.deptno=case
when d.deptname in (select
deptname
from xdepartments
)
then
20
else
50
end
);

In the place of subquery "select deptname from xdepartments" , if I use hardcoded values like 100,200,3000 then it is working fine but I don't know why It is not working if I use subquery like above It's giving an error message..
Please Help me out...
I am using teradata SQL Assistant 7.1
and getting Error message as : Illegal expression in when clause of case expression.
Please help me out
Thanx

Regards,
jack

JACK

Post #11386