[tariquetuku]

the bill,paid and exempted are floating point variable.
but when i run the query, the column of due outputs just blank while the sum(bill.exempted) returns 0. which is rubbish.
Why it happens, why the due column is 0 whenever the sum(bill.exempted) is zero?

Can anyone say it.

The query is placed below:

Expand|Select|Wrap|Line Numbers

1. select cc, sum(bill)as b,sum(paid)as p, sum(exempted) as ex, sum(bill.bill-bill.paid)-sum(bill.exempted)  AS due from bill group by cc

[r035198x]

Add a where clause to select only where those columns are not null.