Axel Richter: Problem bei LEFT OUTER JOIN

Beitrag lesen

SELF-Forum

Problem bei LEFT OUTER JOIN

Axel Richter
– Informationen zu den Bewertungsregeln

Hallo,

SELECT news.NEWS_ID, news.Topic, news.Nachricht, news.Verfasser, news.Quelle, news.Datum, count(comment.KOMM_ID) FROM News as news LEFT OUTER JOIN Kommentare AS comment ON news.NEWS_ID=comment.NEWS_ID GROUP BY comment.NEWS_ID ORDER BY news.Datum

Zählt MySQL NULL-Werte? Probiere mal:

SELECT news.NEWS_ID, news.Topic, news.Nachricht, news.Verfasser, news.Quelle, news.Datum, count(IFNULL(comment.KOMM_ID,1)) FROM News as news LEFT OUTER JOIN Kommentare AS comment ON news.NEWS_ID=comment.NEWS_ID GROUP BY comment.NEWS_ID ORDER BY news.Datum

viele Grüße

Axel

Beitrag melden
–
Informationen zu den Bewertungsregeln