SELECT f.CodFuncionario,
f.funcionario_Nome
FROM funcionario f
WHERE f.funcionario_CodEmpresa = 179
AND EXISTS(SELECT 1
FROM examefuncionario ef
WHERE ef.exameFunc_CodFuncionario = f.CodFuncionario
AND DATE_FORMAT(ef.exameFunc_Data, "%Y") = '2018'
AND ef.exameFunc_Natureza <> 'D')
AND NOT EXISTS(SELECT 1
FROM examefuncionario ef
WHERE ef.exameFunc_CodFuncionario = f.CodFuncionario
AND DATE_FORMAT(ef.exameFunc_Data, "%Y") = '2018'
AND ef.exameFunc_Natureza = 'D')
GROUP BY f.CodFuncionario
ORDER BY f.funcionario_Nome ASC
Discussion between Sorack and José Luis
