No Result Set From Tables Joined with Outer Then Inner Join

CAUSE

When an inner join follows an outer join, the inner join attempts to retrieve records from the result set created by the outer join. If the result set from the outer join contains no records from the second table, then there are no records from the second table to compare in the inner join.

If you look at the SQL query statement that is generated by your query, you will see that the records in the FROM clause (created by the outer join) are the result set from which the WHERE clause (created by the inner join) operates.