SELECT M.Mno, M.Madi,M.Msoyadi, count(*) AS TOPLAMARAC FROM musteri AS M
LEFT JOIN alim AS A ON M.Mno = A.Mno
GROUP BY M.Mno, M.adi,M.soyadi