'ref' accesses to all tables that are direct children of the nested join and are 
not inner wrt their siblings.