upangka

Field<?>[] fields = USER_SCORE.fields();
List<Field> f = new ArrayList<>(Arrays.asList(fields));
f.add(USER.USERNAME);
f.add(USER.MOBILE);
Field<?>[] myFields = f.toArray(new Field<?>[0]);
Record myRecord = db().newRecord(myFields);

List<? extends Record> fetch = db().select(myFields)
  .from(USER_SCORE.leftJoin(USER).on(USER_SCORE.USER_ID.eq(USER.USER_ID)).leftJoin(USER_TAG).on(USER_SCORE.USER_ID.eq(USER_TAG.USER_ID)))
  .where(USER_SCORE.DESC.eq(VersionName.SUB_3_SIGN_SCORE))