Results 1 to 5 of 5
Thread: Combining two tables
Jan 27, 2005, 04:53 #1
- Join Date
- May 2004
- 0 Post(s)
- 0 Thread(s)
Combining two tables
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?