Probemos esto:
Código SQL:
Ver originalSELECT b.codnom , SUM(b.valsal) valsal2
FROM sno_personal a INNER JOIN sno_hsalida b ON a.codper = b.codper
WHERE
a.cedper LIKE 'xxxxxxx'
AND b.codnom IN('0102', '0728', '0755', '0761', '0799', '0829', '0868', '0883')
AND tipsal='A'
AND b.codperi<'017'
GROUP BY b.codnom