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.