SQL question - help
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.
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.