I have a case statment with similar criteria's in them:
Case when role = '8020' and id in (select id from exec) then 'Exec Bonus'
when role = '8020' and not id in (select id from exec) then 'Monetary'
Else '' end.
What is happening is the ones that are not in "exec" are coming back blank? It looks like only the first part of the case statement is being met and I am thinking it is because they are both looking at role =
'8020'. How can I get around this issue?
Thanks a million!!
Case when role = '8020' and id in (select id from exec) then 'Exec Bonus'
when role = '8020' and not id in (select id from exec) then 'Monetary'
Else '' end.
What is happening is the ones that are not in "exec" are coming back blank? It looks like only the first part of the case statement is being met and I am thinking it is because they are both looking at role =
'8020'. How can I get around this issue?
Thanks a million!!