switching projection to outer join, and throwing error.  Also started to refactor for checking partition numbers are aligned in order, but didn't finish that.