SELECT HIGH_PRIORITY,
L.CODFUNCIONARIO,
F.NOME,
( SELECT ENDERECO
FROM LOCALIZACAO
WHERE ENTRADAMANHA_LAT Is Not Null AND CODFUNCIONARIO=L.CODFUNCIONARIO AND DATA=L.DATA ) AS ENTRADA_MANHA,
( SELECT ENTRADAMANHA_H
FROM LOCALIZACAO L1
WHERE ENTRADAMANHA_LAT Is Not Null AND L1.CODFUNCIONARIO=L.CODFUNCIONARIO AND L1.DATA=L.DATA) AS HORA_ENTRADA_MANHA,
( SELECT ENDERECO
FROM LOCALIZACAO
WHERE SAIDAMANHA_LAT Is Not Null AND CODFUNCIONARIO=L.CODFUNCIONARIO AND DATA=L.DATA ) AS SAIDA_MANHA,
( SELECT SAIDAMANHA_H
FROM LOCALIZACAO L1
WHERE SAIDAMANHA_LAT Is Not Null AND CODFUNCIONARIO=L.CODFUNCIONARIO AND L1.DATA=L.DATA ) AS HORA_SAIDA_MANHA,
( SELECT ENDERECO
FROM LOCALIZACAO
WHERE ENTRADAINTERVALO_LAT Is Not Null AND CODFUNCIONARIO=L.CODFUNCIONARIO AND DATA=L.DATA ) AS INTERVALO,
( SELECT ENTRADAINTERVALO_H
FROM LOCALIZACAO L1
WHERE ENTRADAINTERVALO_LAT Is Not Null AND CODFUNCIONARIO=L.CODFUNCIONARIO AND L1.DATA=L.DATA) AS HORA_INTERVALO,
( SELECT ENDERECO
FROM LOCALIZACAO
WHERE SAIDATARDE_LAT Is Not Null AND CODFUNCIONARIO=L.CODFUNCIONARIO AND DATA=L.DATA ) AS SAIDATARDE,
( SELECT SAIDATARDE_H
FROM LOCALIZACAO L1
WHERE SAIDATARDE_LAT Is Not Null AND CODFUNCIONARIO=L.CODFUNCIONARIO AND L1.DATA=L.DATA) AS HORA_SAIDATARDE,
( SELECT ENDERECO
FROM LOCALIZACAO
WHERE ENTRADAEXTRA_LAT Is Not Null AND CODFUNCIONARIO=L.CODFUNCIONARIO AND DATA=L.DATA ) AS ENTRADAEXTRA,
( SELECT ENTRADAEXTRA_H
FROM LOCALIZACAO L1
WHERE ENTRADAEXTRA_LAT Is Not Null AND CODFUNCIONARIO=L.CODFUNCIONARIO AND L1.DATA=L.DATA) AS HORA_ENTRADAEXTRA,
( SELECT ENDERECO
FROM LOCALIZACAO
WHERE SAIDAEXTRA_LAT Is Not Null AND CODFUNCIONARIO=L.CODFUNCIONARIO AND DATA=L.DATA ) AS SAIDAEXTRA,
( SELECT SAIDAEXTRA_H
FROM LOCALIZACAO L1
WHERE SAIDAEXTRA_LAT Is Not Null AND CODFUNCIONARIO=L.CODFUNCIONARIO AND L1.DATA=L.DATA) AS HORA_SAIDAEXTRA
FROM
LOCALIZACAO L,
LANCAMENTO LA,
FUNCIONARIO F
WHERE
CODFUNCIONARIO=84
AND
L.CODFUNCIONARIO = F.CODIGO
AND
LA.FUNCIONARIO = L.CODFUNCIONARIO
AND
L.DATA BETWEEN 20210125 AND 20210127
GROUP BY
L.DATA