Hello everyone,
As I wrote in the subject, I have written the next code but I am getting the error aforementioned.
Could someone tell me where are the mistakes? Mainly because the console does not specify where it is.
------------------------------------------------------------------------------------------
select case when ((select EMPRESA
from B_LISTA_EMPLEADOS
where USERNAME = 'ADMIN')) = 'IMASA'
then ((select JORNADA_ANUAL
from B_JORNADAS_Y_RATIOS
where CATEGORIA = ((
select CATEGORIA
from B_LISTA_EMPLEADOS
where USERNAME = 'ADMIN'
))
and EMPRESA = ((
select EMPRESA
from B_LISTA_EMPLEADOS
where USERNAME = 'ADMIN'
))
and AÑO = '2013'
))
else 'No es un empleado de la empresa'
end case;
as Jornada
from B_JORNADAS_Y_RATIOS
------------------------------------------------------------------------------------------
Best regards