implemented left join on cube join