Self taught (and poorly at that) on SQL and I ran into something I cannot figure out if it is possible. I need to query CI with a child account to get the parent, then query CI with the parent to get ...

I have to design a SQL query on an Oracle 10 DB. I want to do it in an elegant way and avoid, if possible, using sub-queries and in the most portable way possible. Basically it's query involving 3 ...