[[poliburro]]

Código SQL [-]
 

     Select Niveles.Codigo, Niveles.Nombre, Sueldo.Monto
       From Empleado As Empleado
Inner Join Empleos As Empleos
           On Empleado = Empleado.Cedula = Empleos.Cedula
Inner Join Cargos As Cargos
           On Empleos.Cod_Cargo = Cargos.Codigo
Inner Join Niveles As Niveles
           On Cargos.CodigoNivel = Niveles.Codigo
  Left Join (
                      Select Cedula, Sum(VALORDV ) As Monto
                        From nomina 
                      where codigoc = '010'
                 Group By Cedula
                ) Sueldo
         On Empleado.Cedula = Sueldo.Cedula