[mysql] Problem ze złożonym zapytaniem, GROUP BY Opcje

[tommy4]

[SQL] pobierz, plaintext 
SELECT n.title AS ntitle, n.content AS ncontent, n.id AS nid, n.longcontent AS nlongcontent, 
n.date AS ndate, u.avatar AS uavatar, n.comments AS ncomments, n.sourceaddress AS nsourceaddress,
 n.sourcename AS nsourcename, n.lev AS nlev, n.onlyfor AS nonlyfor, u.nick AS nauthor, 
u.gang AS ngang, u.lev AS ulev, u.id AS uid, COUNT(c.id) AS commentscount FROM news AS n,
 users AS u INNER JOIN comments AS c ON c.what='N' 
WHERE u.id = n.author AND c.id_what = n.id 
GROUP BY n.id ORDER BY n.date DESC LIMIT 11
[SQL] pobierz, plaintext 

Te o to zapytanie nie zwraca mi niestety newsów, które nie mają komentarzy. (IMG:http://forum.php.pl/style_emoticons/default/sad.gif) Czy ktoś wie, jak to naprawić?


---------------------
poprawiłem kod,
aby strona się nie rozjeżdżała
~Cienki1980

[Norbas]

Spróbuj:

[SQL] pobierz, plaintext 
SELECT ...
FROM news AS n, users AS u
LEFT JOIN comments AS c ON [b](c.what='N' AND c.id_what = n.id)[/b]
WHERE u.id = n.author 
GROUP BY n.id ORDER BY n.date DESC LIMIT 11
[SQL] pobierz, plaintext