[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

[arecki]

Spróbuj zmienić INNER JOIN na LEFT JOIN

[tommy4]

nadal nic

[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 

[tommy4]

działa wielkie dzięki. Nie wiem czemu, ale jak pisałem c.id_what = n.id w nawiasie kiedyś to dostawałem komunikat, że brak kolumny n.id... Musiałem coś z syntaxem nie tak zrobić. Jeszcze raz wielkie dzięki. (IMG:http://forum.php.pl/style_emoticons/default/smile.gif)