Para facilitar na conferência dos valores de diferenças gerados na contabilização da folha de pagamento, criamos o select abaixo: SELECT DISTINCT(SRZ.RZ_PD), ((SELECT SUM(SRZ2.RZ_VAL) FROM SRZ010 SRZ2 WHERE SRZ2.RZ_FILIAL = SRZ.RZ_FILIAL AND SRZ2.RZ_MAT <> 'zzzzzz' AND SRZ2.RZ_CC <> 'zzzzzzzzz' AND SRZ2.RZ_PD = SRZ.RZ_PD) - (SELECT SUM(SRC.RC_VALOR) FROM SRC010 SRC WHERE SRC.RC_FILIAL = SRZ.RZ_FILIAL AND SRC.RC_PD = SRZ.RZ_PD )) DIFERENCA FROM SRZ010 SRZ WHERE SRZ.RZ_FILIAL = '01' AND ((SELECT SUM(SRZ3.RZ_VAL) FROM SRZ010 SRZ3 WHERE SRZ3.RZ_FILIAL = SRZ.RZ_FILIAL AND SRZ3.RZ_MAT <> 'zzzzzz' AND SRZ3.RZ_CC <> 'zzzzzzzzz' AND SRZ3.RZ_PD = SRZ.RZ_PD) - (SELECT SUM(SRC.RC_VALOR) FROM SRC010 SRC WHERE SRC.RC_FILIAL = SRZ.RZ_FILIAL AND SRC.RC_PD = SRZ.RZ_PD )) NOT IN (0); Veja o resultado prático: Tabela SRZ: ![](/download/attachments/274317547/image2017-5-15%2012%3A5%3A59.png?version=1&modificationDate=1494861058000&api=v2)
Tabela SRC: ![](/download/attachments/274317547/image2017-5-15%2012%3A6%3A40.png?version=1&modificationDate=1494861058000&api=v2)
Select SQL: ![](/download/attachments/274317547/image2017-5-15%2012%3A8%3A6.png?version=1&modificationDate=1494861058000&api=v2)
|