probs with query (sql server/asp)

hi there!

i have a problem with a query (sql server/asp), would be nice if someone could help me ;-)

table:
*****
cats

cols:
***
id (primary key)
id_firm
name
order
order_sub
subs

exmaple: (...hope the formatting resists)
******

id id_firm name order order_sub subs
1 4 Contact 1 0 0
2 4 Support 2 0 3
3 4 Domain 2 1 0
4 4 Grafics 2 2 0
5 4 Webpages 2 3 0
6 4 Hotlines 2 4 0
7 4 Links 3 0 0

description:
**********

order symbolises a category;
order_sub symbolises a sub-category;


this query should build the contents of a menu on a specific asp-page, in this case:

Contact
Support : Domain : Grafics : Webpages : Hotlines
Links


problem:
******
my problem is that i have to delete the column "subs" for administrative purposes and that i want to

create the values of this column automatically in a query or in a view. i tried out everything but

couldn't get it working.

i need a query or a view that i can call from the specific asp-page that gives me exact the same

output as the table shows above but with the difference that the column "subs" doesn't exist in the

table and is virtually created through the query or view. it is also possible to create multiple

combined views to get this output.

thanks in advance,

chris benz
chris080179@hotmail.com