Hierarchical Query

[tabreaz]

A university application have following design


Curriculum:
Curriculum_ID(PK), Curriculum_Year, ...

Major:
Major_ID(PK), Major_Code, Major_Desc, ...

Category:
Category_ID(PK), Category_Short_DESC, Category_Short_DESC, ...

Course:
Course_ID(PK), Course_Code, Course_Desc, ...

Curriculum_Plan:
Plan_ID(PK), Curriculum_ID(FK to Curriculum), Major_ID(FK to MAjor),
Category_ID(FK to Category), Total_Credit_Hours, ....

Course_Curriculum_plan:
Course_Plan_ID(PK), Curriculum_Plan_ID(FK to Curriculum_Plan),
Credit_Hours, ....


Course_Dependents:
Course_ID(Fk to Course), Course_Dependent_ID(Fk to Course),
Course_Plan_ID(Fk to Course_Curriculum_Plan)....

A Course can have more then One Dependent

------>


I have the data inserted into Course_Dependents, I'm facing problem in displaying the course in Hierarchical format. Please someone help me in this.

I'm looking for a query which displays output as, with COURSE_DESC:



Java
C++
C
Computer Basic
IT Basics
Mathematics I
Mathematics II
Mathematics I


Its not a homework