Select and Case statement

[morfasie]

Why can't I do this??
Select (case production.`Policy Name` when 'Pensioner Funeral Plan' then ( select b.`Policy Number`
from pensionerfuneralplan b, production a where b.`Policy Number` = a.`Policy Number`) end)
from production

I want the select inside the case???

Thanks

 

[r937]

pretty tricky, especially since you give no ELSE clause for the CASE

it appears you do not need the "b" table at all, since when you do want it, the only column you want is b.`Policy Number` and that's equal to a.`Policy Number` anyway

select 
  case when `Policy Name` 
        = 'Pensioner Funeral Plan' 
       then `Policy Number` 
   end 
 from production

rudy

http://r937.com/

SQL Consulting