my requirement is that i have get the details about the parentid's along with the recursive data' in a single join
Test question?
I've been taking buisness requirements for years, and never once has "in a single join" been specified as a requirement. So who made it mandatory for you?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills