How to set 0 when the count row display Null?

Question

So, I have this sql:

SELECT program.BilanganTerhad - IFNULL(COUNT(daftarprogram.KodProgram), 0) AS kiraan
FROM program, daftarprogram
WHERE program.KodProgram = daftarprogram.KodProgram
  AND daftarprogram.KodProgram = '19'

How can I set the null COUNT() value to 0? For example: 10 - null = null instead of 10 - 0 = 10.
I need the count become 0, not null.

This is value from table1

While this is value from table2

I want to subtract value from table1 and minus with count(kodprogram)

The thing is I want to subtract value from table1 with count(KodProgram) from table2 based on where condition = KodProgram

Answer 1

COUNT() never returns NULL. That said, your query is malformed (in addition to using archaic join syntax. BilanganTerhad is in the SELECT but it is an aggregation query.

Perhaps you intend:

SELECT p.BilanganTerhad - COUNT(*) AS kiraan
FROM program p JOIN
     daftarprogram dp
    ON p.KodProgram = dp.KodProgram 
WHERE dp.KodProgram = '19'
GROUP BY p.BilanganTerhad;