[SQL] JOIN che non restituisce risultato ...

[whisher]

Ciao.
Scusate il titolo un po bislacco

Faccio una query del genere (questa
è quella + facile nel senso che ha
una where senza AND )

SELECT p.post_ID AS id, p.post_title AS title, p.post_preamble AS preamble, 
        u.user_name AS author, u.user_ID AS uid, c.category_ID AS cid, c.category_title         AS ctitle,count( co.post_ID ) AS ncomment 
        FROM posts AS p INNER JOIN users AS u ON p.user_ID=u.user_ID
        INNER JOIN categories AS c ON p.category_ID=c.category_ID
        LEFT JOIN comments AS co ON p.post_ID =co.post_ID 
        WHERE co.comment_approved='1'
        GROUP BY p.post_ID DESC LIMIT 0 , 30; 

Il problema è che se il post non ha nessun commento approvatonon mi restituisce niente come posso ovviare
a sto inconveniente

[whisher]

UHm
Così sembrerebbe funzionare

SELECT p.post_ID AS id, p.post_title AS title, p.post_preamble AS preamble, 
        u.user_name AS author, u.user_ID AS uid, c.category_ID AS cid, c.category_title         AS ctitle,count( co.post_ID ) AS ncomment 
        FROM posts AS p INNER JOIN users AS u ON p.user_ID=u.user_ID
        INNER JOIN categories AS c ON p.category_ID=c.category_ID
        LEFT JOIN (SELECT post_ID FROM comments WHERE comment_approved='1') 
        AS co ON p.post_ID =co.post_ID 
        GROUP BY p.post_ID DESC LIMIT 0 , 30; 

Se mi date il VS autorevole parere vi sarei enormemente
grato