Answering to meg evans...

I think the good way to do this is :

[font="Courier New"]With tree (id, name)

AS

(Select parent_id, name

from clients

where parent_id = 1

Union all

Select parent_id, name

from clients c

INNER JOIN tree t

ON c.id = t.id

)

Select *

from tree[/font]

A + (wich means in french "see u later")