Use inner join conditions in outer join promotion

Along with where conditions. These are pulled together by the group join finder, but that's run later than this.

One would not expect queries like the new left-inner test to be written by hand, but they can come out of frameworks.