consulta dos tablas con group by

[Heimish2000]

Código SQL:

SELECT T1.no_emple, T1.nombre, SUM(mes1), SUM(mes2)
FROM tabla1 T1
INNER JOIN tabla2 T2 ON
T1.no_emple = T2.no_emple
GROUP BY T1.no_emple, T1.nombre