in a simple tree structured table<br /><br />table t(<br /> id primary key,<br /> pnt_id references t( id ),<br />
name<br/>);<br /><br />does anyone know an easy howbeit sneaky way of determining ancestory and decendency without
recursivefunctions,<br /><br />select name from t where exists <ancestor or descendent><br /><br />thanks for
insight<br/><p><hr size="1" />Get your own <a href="
http://us.rd.yahoo.com/evt=43290/*http://smallbusiness.yahoo.com/domains">webaddress for just $1.99/1st yr</a>. We'll
help.<a href="http://us.rd.yahoo.com/evt=41244/*http://smallbusiness.yahoo.com/">Yahoo! Small Business</a>.