I’ve the next doubt, I’ve this code:
select DISTINCT case when lppp.TipoLugarProduccion = 3 THEN
lppp.Id_LugarProduccion
ELSE 99999 end from LineasProduccionPorParte lppp
I’d like to do two ELSE:
- ELSE 99999
- ELSE 2027
Like this:
select DISTINCT case when lppp.TipoLugarProduccion = 3 THEN
lppp.Id_LugarProduccion
ELSE 99999 OR ELSE 2027 end from LineasProduccionPorParte lppp
But I’m getting error.
Do you know how can I do it?
You need to sign in to view this answers