Subversion Repositories Integrator Subversion

SELECT vendedor.dsc_nome, SUM(pagamento.val_pagamento) FROM sc_sec.sec_venda venda
LEFT JOIN sc_sec.sec_vendedor vendedor ON venda.seq_indicacao=vendedor.seq_vendedor
LEFT JOIN sc_sec.sec_venda_formapagament pagamento ON venda.seq_venda = pagamento.seq_venda
WHERE venda.seq_indicacao IS NOT NULL AND venda.dth_venda BETWEEN '2014-12-12 00:00:00' AND '2015-01-28 00:00:00'
GROUP BY vendedor.dsc_nome