msc: fix the outer join syntax