What you're seeing here is an outer join. The idea is relatively involved, so I recommend reading up on Philip's SQL guide at photo.net/sql. We're porting a bunch of these already (check out the porting guide in the manual page), however this one isn't ported because of the "connect by" which we haven't been able to solve yet... Another Oracle construct.
