[ic] recursive perl subroutine

[interchange-users@icdevgroup.org (John Allman)]

cfm@maine.com wrote:
[snip]
> If this is a guaranteed shallow tree, you might write it instead as an
> SQL LEFT JOIN.  If you know it is only three levels, that will
> be just two or three depending on your root.
[/snip]

i'm not precicely an expert on sql either, but i'm not following you. i 
can guarantee that its a shallow tree but i cant guarantee its depth. it 
could be anywhere from 1 to 3 levels. i dont suppose you'd care to put 
down an example of some sql that might be applicable? i just dont see 
how a join would help?

thanks!

John