right outer join
fix bug with right outer join