Code
SELECT t1.POST_ID FROM 
ubbt_POSTS as t1,
ubbt_TOPICS as t2
where t1.TOPIC_ID=t2.TOPIC_ID
and t2.FORUM_ID=4

This will give you all the post_id's that are in forum 4.

[Linked Image from siemons.org]