I tried replacing the full join with a union of a left and right join. I get a different result (!) but not the one I need.