code: private void appendJoin(StringBuffer where, StringBuffer buf, Join join)
      {
          buf.append(",");
          appendTableWithJoins(join.right, where, buf);
          if (where.length() > 0)
          {
              where.append(" AND ");
          }
          join.appendJoinEqualities(where);
      }
docs: Append Join for non SQL92 Syntax