code: private void appendJoinSQL92(Join join, StringBuffer where, StringBuffer buf)
      {
          if (join.isOuter)
          {
              buf.append(" LEFT OUTER JOIN ");
          }
          else
          {
              buf.append(" INNER JOIN ");
          }
          if (join.right.hasJoins())
          {
              buf.append("(");
              appendTableWithJoins(join.right, where, buf);
              buf.append(")");
          }
          else
          {
              appendTableWithJoins(join.right, where, buf);
          }
          buf.append(" ON ");
          join.appendJoinEqualities(buf);
      }
docs: Append Join for SQL92 Syntax