Hi guys

I have a situation where i am trying to extract the descendants of a particular entry. 

So long story short, i have the Account table with Agency (A) id = 1, and that has child Agency (B) id = 2. This child agency (B) has a child agency (C) id = 3. This child agency (C) has a child agency (D) id = 4. 

So in essence we have have a pyramid setup where each level has other child agencies underneath. The number of levels differ per the preceding Agency.

My question now is, in Analytics how do i write a heirachical query that takes into account all the levels (or rather extract). 

As it is if i write this query: select * from Account where id = 1, it only brings up the first level (Agency B) but i want to have that query show all the agencies (A, B, C, D)