Difference between two columns

[budimir]

Guys how can I make this query work

SELECT SUM(iznos_fakture) as ukupno 
FROM fakture_placanja 
WHERE iznos_placanja != iznos_fakture 
AND MONTH(datum_dospijeca) = '12' 

I need to find where iznos_placanja is different from iznos_fakture. They are two columns in same DB?

 

Any ideas?

[Barand]

If we knew

• your input data,
• what you are getting
• and what you expect to get

then maybe we'd have some ideas.

Edited December 15, 2015 by Barand

[budimir]

iznos_fakture (DECIMAL (10,2)) is amount of invoice to be payed

iznos_placanja (DECIMAL (10,2)) is amount payed for that invoice

MONTH(datum_placanja) is month when that invoice is due

 

I would like to find all invoices in december that are not yet payed. I see in table that there are two invoices not payed. For some reason I can't display them. No errors. I'm getting empty result.

Edited December 15, 2015 by budimir

[budimir]

Found a problem. It was nulls allowed and it should be 0 in all records.