Joe Sweet wrote:
> SELECT ...
> FROM phpbb_posts p, phpbb_users u, phpbb_posts_text pt, phpbb_batlerecord br
> WHERE p.topic_id = 487
> AND pt.post_id = p.post_id
> AND u.user_id = p.poster_id
> AND br.user_id = p.poster_id
> ORDER BY p.post_time DESC
> LIMIT 0, 10
>
> Is there any way (outer/inner/whatever join) that the statement returns a row for every member
SELECT ...
FROM phpbb_posts p, phpbb_users u, phpbb_posts_text pt
LEFT JOIN phpbb_batlerecord br ON br.user_id = p.poster_id
WHERE p.topic_id = 487
AND pt.post_id = p.post_id
AND u.user_id = p.poster_id
ORDER BY p.post_time DESC
LIMIT 0, 10
--
felix
Please use
BBCode to format your messages in this forum.