Hi

I'm not used to set join queries so i'd like to ask help for this case.

I have two tables with fields:

forums:
forum_id
forum_priviledge

topics:
topic_id
topic_title
topic_created
topic_forum_id

now i'd like to get 5 newist topics from all forums, where priviledge is 0!

something like

SELECT topics.topic_id, topics.topic_title
FROM topics
WHERE forums.forum_id=topics.topic_forum_id AND forums.forum_priviledge=0
ORDER BY topics.topic_created
ORDER ASC
LIMIT 5

But i think i need to join this to get it work or how does it work?

Regards,
Marko