[sql generation] fix missing join with outer joins w/ rhs invariant variable... ... where the principal where not the processed relation. This led to major refactoring in outer join handling, which is now much clearer and powerful. Closes #1579228

<div id="ajaxroot">
  <div class="ajaxHtmlHead">
    <script src="http://foo.js" type="text/javascript"> </script>
  </div>
  <h1>Hello</h1>
</div>