Combining two tables

[pht]

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

[lilleman]

Hi,

Let me see if I have understood you correctly. Do you want to obtain the five newest topics in all forums (five from the first forum, five from the second forum etc.), or just the five newest topics (regardless of which forum they were posted in) ?

Yours, Erik.

[pht]

Just the five newest topics regardless of which forum they were posted in. Sorry for unexact problem description.

[r937]

select topic_id
     , topic_title
     , topic_created
     , topic_forum_id
  from topics
inner
  join forums
    on topic_forum_id
     = forum_id  
 where forum_priviledge = 0     
order
    by topic_created desc
limit 5

[pht]

Thank You!