Clientes

SELECT NF.CODINTNF AS CODINTNF, NF.CODIGOEMPRESA AS EMPRESA, NF.CODIGOFL AS FILIAL, NF.CODIGOGA AS GARAGEM, NF.SERIENF AS SERIE, NF.NUMERONF AS NUMERO, TO_DATE(NF.DATAEMISSAONF) AS DATA, NF.CODIGOFORN AS CODFORN, FO.RSOCIALFORN AS FORNECEDOR, SUM(SE.VALORNFSERVICO) AS VR_SERVICO, SE.CODIGOVEIC AS VEICULOS, SE.DESCRICAONFSERVICO AS DESCRICAO FROM BGM_NOTAFISCAL NF, EST_NFSERVICO SE, BGM_FORNECEDOR FO WHERE NF.DATAEMISSAONF >= ’01-JAN-2022′AND NF.CODINTNF= SE.CODINTNFAND NF.CODIGOFORN=FO.CODIGOFORN GROUP BYNF.CODINTNF, NF.CODIGOEMPRESA, NF.CODIGOFL,...