David,

I wouldn't fret over it at all. Your join is producing the outer join you specified, but then thw WHERE coditions eliminated all the records that had no Order_dt so it appeared that teh join was wrong when, in fact, it was fine. Your filter was too aggressive is all.