Forum OpenACS Q&A: Response to Help with query with CONNECT BY and outer join

Thanks Dan an Don. I suspected I had to put the condition out of the internal subquery, but wasn't sure.

One thing I didn't catch though, is why did it need to be a RIGHT outer join?