tree-structured query

[chester c young <chestercyoung(at)yahoo(dot)com>]

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,

select name from t where exists <ancestor or descendent>

thanks for insight

---

Get your own web address for just $1.99/1st yr. We'll help. Yahoo! Small Business.