>What is the result you are getting?
This is the result I am getting:

1,1,A
2,1,AA
3,2,AAA
4,4,a
5,4,aa
6,6,einar
7,3,AAAA
8,7,AAAAA
9,5,aaa

which I guess makes sense based on the select statement, but the select statement is wrong based on the result i want.

Einar