SELECT
S.CODIGO, SUM( S.SALDO ) AS SALDO
FROM
SALDOCONTABIL S
INNER JOIN PLANOCONTABIL P ON P.CODIGO = S.CODIGO
WHERE
S.DATA BETWEEN dDataI AND dDataF AND
S.CODIGO = XNumAux
GROUP BY
S.CODIGO

Moderador: Moderadores
SELECT
S.CODIGO, SUM( S.SALDO ) AS SALDO
FROM
SALDOCONTABIL S
INNER JOIN PLANOCONTABIL P ON P.CODIGO = S.CODIGO
WHERE
S.DATA BETWEEN dDataI AND dDataF AND
S.CODIGO = XNumAux
GROUP BY
S.CODIGO
Usuários vendo este fórum: Nenhum usuário registrado online e 8 visitantes