Hi,

I have a table like this:

id parent descr
---- ------ -----
1 - house
2 - cat
3 - dog
4 3 chair
5 - bed
6 2 lap

Let's say I want to grab the id = 4 but at the same time I want to grab the parent of 4 also, so the result should be

id parent descr
---- ------ -----
4 3 chair
3 - dog

What is the easiest way to do this in one Select Statement?

Thanks.