Re: What looks like a basic SQL query still not resolved
Posted by Andy Kent on 11/17/05 13:32
Oracle has a CONNECT BY clause to do recursive joins like this - not a
help to you as such, but the point is that they have found it necessary
to have a specific feature to accomplish what you're trying to do. They
used to call the technique "tree walking". Don't know if SQL Server has
something similar ...