with Myft as (select ft.fdata, ft.no, ft.estab, ft.ftstamp, ft.tipodoc, sum(fi.etiliquido) AS 'Valor' FROM ft inner join fi on (fi.ftstamp = ft.ftstamp)where fi.stns = 0 GROUP BY ft.ftstamp, ft.no, ft.estab, ft.tipodoc, ft.fdata)SELECT cl.nome, cl.vendnm AS 'Vendedor', SUM(myft.valor) AS 'Vendas'FROM cl left outer join Myft ON (cl.no = myft.no AND cl.estab = myft.estab AND myft.tipodoc IN (1,3) AND myft.fdata BETWEEN '20090101' AND '20091231')GROUP BY cl.vendnm, cl.nome;