Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT fun.documento as documento_evaluador, fun.nombre as Nombre_Evaluador, (select documento from funcionario where id= resul.idFuncionario) as documento, (select nombre from funcionario where id= resul.idFuncionario) as Nombre_Evaluado, FORMAT (AVG(resul.valor),0) as valor, carcom.esperado as valor_esperado, (SELECT IF(valor<valor_esperado, 'inferior', '')) AS inferior, (SELECT IF(valor=valor_esperado, 'esperado', '')) AS esperado, (SELECT IF(valor>valor_esperado, 'superior', '')) AS superior , comp.nombre as nombre_competencia, obj.observaciones, obj.fortalezas, obj.oportunidades, obj.formacion from resultados resul, competencia comp, funcionario fun, nucleo nuc, cargoCompetencia carcom, objetivos obj where resul.idEvaluador = fun.id and resul.nucleo = nuc.id and nuc.idCompetencia = comp.id and carcom.idCargo = fun.cargo and obj.idFuncionario = resul.IdFuncionario GROUP BY Nombre_Evaluado, comp.id</code>
- obj.observaciones, obj.fortalezas, obj.oportunidades, obj.formacion
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement