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.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  Show specific group first in list

Author  Topic  Joe Starting Member 3 Posts Posted - 2001-03-27 : 10:33:46 I have a database containing articles each of which has a category assigned to it. The categories are in another table and there is a match table between the article and category tables. On top of that, there is a category group table which groups the categories and there is a match table between that table and the category table. I get a category ID from the user, find the group that the category is in, find all the categories that are in that group and then find all the articles in those categories. My question is (finally): How can I show the articles with the supplied category ID first in the list? Ordering by categoryID won't give me what I want. Thanks for any help.