The page the query is called on is when viewing a forum thread. In the query I select from the forum_posts table and join the forum_threads table. I'm trying to figure out if I can select data from the forum_forums table to fetch the post/reply permissions.

Table / Unique ID (via Alias)
forum_forums = ff.id
forum_threads = ft.id
forum_posts = fp.id

This is what my current query looks like slimmed down...

SELECT *
FROM forum_posts AS fp
INNER JOIN forum_threads AS ft ON (fp.id_thread=ft.id_thread)

I was reading about outer joins...not sure if it's necessary or not. I'm not exactly sure spatially speaking of how outer and inner joins relate exactly.

So is there a way to join the forum_forums table the already joined forum_threads table?

- John