Right join on non-joinable columns
===

My question is simple, suppose i am joining between two tables and one of them is a right join

    select e.name, nvl(e.mobileNumber, c.secondaryNumber)
    from T_employee e, t_contact c
    where e.fieldOfficeCode = 10
    and e.id = c.id (+)
    and c.status = 1001

now if I remove the last line of the query it would do the right join correctly, but once the last line is present I will not get any reslut. Any idea on how to resolve this. Now the query at hand is relatively complex and spans 5 tables but the sample snippet will simplify the actual problem

regards,