If its a single level then
Select
*
From Parent P1
LEFT JOIN Parent P2 on P1.Id=P2.ParentId
If its a multi level then you will need to lookup a Recursive CTE http://msdn.microsoft.com/en-us/library/ms186243(v=sql.105).aspx
_________________________________________________________________________
SSC Guide to Posting and Best Practices