Hi.
I am trying to use two joins in one query, and treat them completely seperately? See my code below for more info:
SELECT a.ID, a.ForumID, a.ForumName, a.ForumDescription, a.CreationDate, count(p.ID) AS NumPosts, count(r.ID) AS NumReplies
FROM forum_cat a INNER JOIN forum_post p ON (a.ID = p.ZoneID) AND p.ForumID = 'varid', forum_reply r INNER JOIN forum_cat b ON (r.ZoneID = b.ID) AND r.ForumID = 'varid'
WHERE a.ForumID = 'varid'
GROUP BY a.ID, a.ForumID, a.ForumName, a.ForumDescription, a.CreationDate
the above shows my query with two joins, but they are not working seperately as two seperate JOINs, how do I "break" them apart to run independantly so I get the correct result back from the query???
Many thanks
S
