• This is one of those cases where your WHERE clause is turning your OUTER into an INNER....

    You're only allowing for non-null "right" records (based on the WHERE clause, so it's not being treated as an outer join anymore....

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?