You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to publice...@googlegroups.com
Hola César
SELECT vd.Nombre , SUM(IF(vt.Tipo = "CONTADO", vt.Monto, 0)) As Contado , SUM(IF(vt.Tipo = "CREDITO", vt.Monto, 0)) As Credito FROM Ventas vt LEFT JOIN Vendedores vd ON vt.IdVendedor = vd.IdVendedor GROUP BY Nombre