MySQL Forums
Forum List  »  General

SQL question - help
Posted by: Mariusz Muszalski
Date: November 10, 2004 02:13AM

have a problem with sql query (mysql 3.23)...

Two tables: groups and topics.
Groups table can be like that:

GroupID | Groupname

Topics table:

TopicID | Topicname | GroupID (foreign key from groups table)

Now want to select list of all the groups together with their topics

E.g.

Group1 Topic1
Group1 Topic2
Group2 Topic3
Group3 Topic4
Group3 Topic5
Group3 Topic6

...and max number of topics returned for each group is 3.

Options: ReplyQuote


Subject
Written By
Posted
SQL question - help
November 10, 2004 02:13AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.