I am guessing you have your left and right mixed up. Presumably the Master_Recieving always exists, and the ORder_detail may or may not exist. That being the case, this is a left, not a right.