This is a great article, but I am running into issues with trying to apply this to my own querey.

if anyone is following this string, could you look at the following and tell me if anything jumps out at you for where i am going wrong?

With tree (id, name) AS

(

Select id, name

from

clients

where

parent_id=1

Union

all (

Select

id, name

from

clients

INNER

JOIN tree t

ON

t.parent_id = t.id)

Select * from tree)

many thanks from one who is just working on this part of the database.