Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mike123
Master Smack Fu Yak Hacker
1462 Posts |
 Posted - 2002-08-20 : 03:02:37
|
| I have a recordset of about 30 records I want to order them byCAT ID first then I would like to order them by FORUM_IDhow can I do this??ThanksExampleselect cat_ID, forum_ID from forum_forum order by cat_IDCATID FORUMID3 53 73 84 14 34 4 |
|
|
Nico
Starting Member
18 Posts |
Posted - 2002-08-20 : 03:21:53
|
| ORDER BY first, second, third, fourth, etcSo in your case:ORDER BY cat_ID, forum_ID |
 |
|
|
|
|
|
order by