显式路径JOIN

// Path joins are created implicitly:
create.select(
          BOOK.author().FIRST_NAME,
          BOOK.author().LAST_NAME,
          BOOK.TITLE,
          BOOK.language().CD.as("language"))
      .from(BOOK)
      .fetch();

// Path joins are created explicitly (e.g. using table lists):
create.select(
          BOOK.author().FIRST_NAME,
          BOOK.author().LAST_NAME,
          BOOK.TITLE,
          BOOK.language().CD.as("language"))
      .from(BOOK, BOOK.language(), BOOK.author())
      .fetch();

// Path joins are created explicitly (e.g. using inner joins, with optional ON clause):
create.select(
          BOOK.author().FIRST_NAME,
          BOOK.author().LAST_NAME,
          BOOK.TITLE,
          BOOK.language().CD.as("language"))
      .from(BOOK)
      .join(BOOK.language())
      .join(BOOK.author())
      .fetch();