SELECT VM.CODIGO, 'PDV' AS TIPO, VM.DATA_EMISSAO,                  VM.SUBTOTAL, VM.DESCONTO, VM.ACRESCIMO, VM.TOTAL,                    CLI.CODIGO AS FKCLIENTE, CLI.RAZAO CLIENTE,                          VEN.CODIGO AS FKVENDEDOR, VEN.NOME VENDEDOR, VD.TOTALVENDA,          VD.TOTALCUSTO, COALESCE(VD.TOTALVENDA - VD.TOTALCUSTO, 0) AS LUCRO   FROM VENDAS_MASTER VM                                                LEFT JOIN PESSOA CLI ON CLI.CODIGO=VM.ID_CLIENTE                     LEFT JOIN VENDEDORES VEN ON VEN.CODIGO=VM.FK_VENDEDOR                LEFT JOIN (                                                             SELECT                                                                    A.FKVENDA AS CODIGO,                                                 COALESCE(SUM(                                                        IIF(COALESCE(A.PR_CUSTO2, 0) > 0, A.PR_CUSTO2 * A.QTD,               IIF(COALESCE(A.PR_CUSTO, 0) > 0, A.PR_CUSTO * A.QTD,                 IIF(COALESCE(B.PR_CUSTO2, 0) > 0, B.PR_CUSTO2 * A.QTD,               IIF(COALESCE(B.PR_CUSTO, 0) > 0, B.PR_CUSTO * A.QTD, 0)              )))), 0) AS TOTALCUSTO,                                              COALESCE(SUM(A.TOTAL), 0) AS TOTALVENDA                          FROM VENDAS_DETALHE A                                                INNER JOIN VENDAS_MASTER VM ON (A.FKVENDA = VM.CODIGO)               LEFT JOIN PRODUTO B ON (A.ID_PRODUTO = B.CODIGO)                     WHERE VM.FKEMPRESA = 1AND (VM.SITUACAO <> 'C') AND (VM.SITUACAO <> 'A')                AND (VM.SITUACAO <> 'X') AND (VM.SITUACAO <> 'G')                 and VM.DATA_EMISSAO between '2025-01-01' and '2025-03-10'                                                            GROUP BY A.FKVENDA                                               ) VD ON VD.CODIGO = VM.CODIGO                                         WHERE VM.FKEMPRESA = 1AND (VM.SITUACAO <> 'C') AND (VM.SITUACAO <> 'A')                AND (VM.SITUACAO <> 'X') AND (VM.SITUACAO <> 'G')                 and VM.DATA_EMISSAO between '2025-01-01' and '2025-03-10'                                                           