Query parent and child entries of one element in a single row

[ockelagyp]

I'm searching for the best way to display parent and child entries in one row.Example:\[code\]Table A ID | PARENT_ID | VALUE=http://stackoverflow.com/questions/2190347/============================ 1 | | A 2 | 1 | B 3 | 2 | C 4 | | D 5 | 4 | E\[/code\]So I want to get the following result:\[code\] ID | PARENT | CHILD | VALUE =http://stackoverflow.com/questions/2190347/======================================== 2 | 1 | 3 | A 5 | 4 | | E\[/code\]How would you solve this? Any help his very appreciated.Daniel