Details | Last modification | View Log | RSS feed
| Rev | Author | Line No. | Line |
|---|---|---|---|
| 1 | espaco | 1 | SELECT vendedor.dsc_nome, SUM(pagamento.val_pagamento) FROM sc_sec.sec_venda venda |
| 2 | LEFT JOIN sc_sec.sec_vendedor vendedor ON venda.seq_indicacao=vendedor.seq_vendedor |
||
| 3 | LEFT JOIN sc_sec.sec_venda_formapagament pagamento ON venda.seq_venda = pagamento.seq_venda |
||
| 4 | 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' |
||
| 5 | GROUP BY vendedor.dsc_nome |