Hi,
I am want on sql statement for my table. I am having one table call friends in that table i will store userid and friendid like this.....


iUserID iFriendID
1 3
1 2
1 4
2 4
3 6
6 2
5 7
7 8

How can i get parent and child record suppose my id is 3 i have to get userid "3"'s parent records and child record. How can i get this all records....

1 3
1 2
1 4
2 4
3 6
6 2

Thanks in advance

not enough info

there is no parent or child column, just user and friend