Ver originalSELECT ProductName,UnitPrice*(UnitsInStock+IFNULL(UnitsOnOrder,0))FROM Products
Ver originalSELECT c.nombre, a.compra, (IFNULL(a.sub,0) + IFNULL(a.iva,0) + IFNULL(a.flete,0) totalFROM clientes c ¿Es correcto?LEFT JOIN acum a on c.cliente = a.cliente