Your first query is fine, as b is out joined to two tables a and a_outter_joined, but your second query is not, as it twice out joined to a. Well oracle can make the error message more clear, saying that "you either out joined two tables, or out joined the same table twice." ;-)