estrazione da più tabelle

[marketto]

prova questa:

SELECT phpbb_posts.post_id, phpbb_posts.forum_id,phpbb_posts_text.post_subject FROM phpbb_posts
INNER JOIN phpbb_posts_text ON phpbb_posts_text.post_id = phpbb_posts.post_id
WHERE forum_id != 10
ORDER BY post_id DESC
LIMIT 10