mardi 8 septembre 2015

SQL COUNT get zero

SELECT COUNT(*) totalStudent,
c.* 
FROM classroom c 
INNER JOIN student s
ON c.classID = s.classID 
GROUP BY c.classID 

How to get zero in totalStudent? if student empty inside the classroom.

Aucun commentaire:

Enregistrer un commentaire