Case statement with Multiple Parameters

[gkrenton]

So trying to do an if statement that's only executed if the 2 things are true.

I have

select
distinct E.inv_id,
E.inv_id||03,
CASE when EC.inv_color like "NO%" AND EC.web_show = 1 then 0 else 9 END
from ecat_items as E inner join ecat_item_color as EC ON E.inv_id=EC.inv_id
where E.web_show=1

But this fails so I'm wondering if I can do a multiple case statement like this.

As always thanks in advance.

-Gina

 

[olded]

Gina:

Are you sure your select is working without the case statement? I ran this select which contains a case statement similar to yours and it works:

select *,
CASE WHEN A.version LIKE "97%" AND A.installed = "N" THEN 0 ELSE 9 END
from db_revision A

 

[gkrenton]

Thanks - actually it does work if one calls the fields correctly. Took re-writing it & reviewing to realize it but yes it does work. Thank goodness.

gina