SELECT 
id_venta AS ID,
folio AS Folio,
c.nombre AS Nombre,
CONCAT('$',FORMAT(total,2)) AS Total,
fecha AS Fecha,
hora AS Hora,
folio_fiscal AS 'Folio fiscal',
IF(v.cancelado=1,'SI','NO') AS Cancelado
FROM ec_ventas v
JOIN ec_clientes c ON v.id_cliente =c.id_cliente 