Hey,

Many many thanks,

This worked like a gem. I met my objective with this solution.

Regards,

K

Agreed that ParentId in my results are not in the table, but that is what I want to generate!!

Your query came up with the following result

ID | ParentID | Name

----------------------

1NULLParent1

21Child1of1

31Child2of1

4NULLParent2

52Child1of2

6NULLParent3

73Child1of3

If...

BANG ON!!

That's what I was looking out for! Thanks mate

-K

Jason : I read those articles. They are excellent!! But afterall, they use aggregate functions and that is not what I want.

BriPan : I tried your query, but still...