Varing Hirarchical Query
Dear all,
I have the data say as follows
Dept
College of Sciences
Physics
Chemistry
Maths
College of Extra Studies (Chairman College of Extra Studies )
Physical Studies
Life Sciences
English
English 1
English 2
Spanish
Spanish 1
Arabic
I have a requirement that if a student is in Physics , Chemistry, Maths -> His Chairman/Manager is Chairman Physics, Chairman Chemistry, Chairman Maths and So on.
and if a student is in English1, English2,, Spanish 1 etc -> His chairman is Chairman English, Chairman Spanish
the sub departments below a depatment is variable ; for eg: English has 2 sub departments and Spanish has 1 sub department