Re: Null Output Problem

2011-10-11 Thread Hal�sz S�ndor
Generally when one has this problem one joins this query with something from which one can get the whole list, something like this: SELECT identifier, IFNULL(c, 0) AS Good, (query with COUNT) AS P RIGHT JOIN table-of-identifiers ON P.identifier = table-of-identifiers.identifier The "c" is

Null Output Problem

2011-10-11 Thread Jon Forsyth
Hello, I have a problem with the following query: SELECT subject_identifier, COUNT(*) FROM asr_sentence_score WHERE total_words = correct_words GROUP BY subject_identifier; OutPut: ++--+ | subject_identifier | COUNT(*) | ++--+ |