Hi Mike,

By using your query i can able to get only the immediate childs of the parent.

For example when i gave 1 as input to that query, i have retrieving only the direct child of 1, in our case iam receiving 2 and 3.But i cannot able to receive all child of parent.

Expecting output:

Input - 1

Output - 2 ,4, 3, 5