Use sql extensions that implement transitive closure queries directly (ie PRIOR or the like)<BR>2.) Code a recursive procedure in your application or as a stored proc<BR>3.) ...