Re: [SQL] tree-structured query

2006-09-30 Thread Ragnar
On fös, 2006-09-29 at 15:00 -0700, chester c young wrote: > in a simple tree structured table > > table t( > id primary key, > pnt_id references t( id ), > name > ); > > does anyone know an easy howbeit sneaky way of determining ancestory > and decendency without recursive functions, how a

[SQL] tree-structured query

2006-09-29 Thread chester c young
in a simple tree structured tabletable t(  id primary key,  pnt_id references t( id ),  name);does anyone know an easy howbeit sneaky way of determining ancestory and decendency without recursive functions,select name from t where exists thanks for insight Get your own web address for just $1.