SQL to find division for employee

 Hi

I'm trying to build a piece of sql which will track an employee's organization chart through the levels of organization.

For example, I can find the 'Sub Team' on the Employee's Assignment form - but if I want to work up the organization hierarchy to find out which 'Division' that 'Sub Team' is in - is there an easy way to go about doing this?

Many thanks

Martin