Creating a self join Hierarchy

[#1]

Hi

Im trying to create a hiererachy on a table using the self join between the LocalServiceLineParent and LocalServiceLine.:

SELECT .LocalServiceLine, .LocalServiceLineDescription,

.LocalServiceLine + ' : ' + .LocalServiceLineDescription AS LocalServiceLineDescriptionWithCode,

               LocalServiceLineParent

FROM  LocalServiceLines

I have tried this in SQL but unfortunatley the results are not returining as expected.

Thanks

[#2]

what do you expect? and what you get? and where is self join?

[#3]

The parent is LocalServiceLineParent and the child is LocalServiceLine.  I need these two join to create a hierarchy.