I think that this "lbzq.Internal(+)=lm.internal AND lbzq.num(+)=lm.num
" is the source of your problems. You need to change the syntax of your outer join. Try using the left outer join clause instead.