Select Ve.Nome,Ve.Comissao,V.Total from Vista V
Left Join Vendedor Ve on V.CodVend=Ve.Codigo
Where V.Pendente=False
Order By Ve.Nome