Ok guys I'll admit this is homework but I've spent two days trying to figure out how to do this last query and I'm simply stumped. I'm pretty sure I know, intellectually how to do it but I can't ...

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 ...