Hi,

i need a query to fetch output similar to that shown below this table on which it is based -

CatId Category ParentCatId
----- -------- ------------
1 Men's Wear 0
2 Full Shirts 1
3 Half Shirts 1
4 Formal 2
5 Casual 2
6 Formal 3
7 Casual 3



field1 field2 field3
-------- ------------ ------------
Men's Wear Full Shirts Formal
Men's Wear Full Shirts Casual
Men's Wear Half Shirts Formal
Men's Wear Half Shirts Casual


Thanks for your time....

Isn't your question essentially the same as this one?
http://p2p.wrox.com/topic.asp?TOPIC_ID=2216