I'm not used to set join queries so i'd like to ask help for this case.
I have two tables with fields:
now i'd like to get 5 newist topics from all forums, where priviledge is 0!
SELECT topics.topic_id, topics.topic_title
WHERE forums.forum_id=topics.topic_forum_id AND forums.forum_priviledge=0
ORDER BY topics.topic_created
But i think i need to join this to get it work or how does it work?