Join union has correct select statements and removes ambiguity

This also throws a new UnsupportedFullOuterJoinException on FULL OUTER JOINs. We weren't really supporting them before, now we're explicit about it.