我無(wú)法使用以下查詢(xún)從兩個(gè)表中獲取所有記錄我已經(jīng)嘗試過(guò)了，但我只從一張桌子上得到結(jié)果。我想要兩個(gè)表的結(jié)果，即 client_software_param_mapping 和 client_file_configuration 具有相同的 ClientId，這是從第三個(gè) pojo(client_software_configuration) 到第一個(gè)和第二個(gè) pojo 的外鍵。public Result showClientConfiguration() {EntityManagerFactory entityManagerFactory =                          Persistence.createEntityManagerFactory("defaultPU");  EntityManager entityManager = entityManagerFactory.createEntityManager();Query q=entityManager.  createQuery("SELECT c FROM client_software_param_mapping c JOIN fetch client_file_configuration f ON c.ClientId=f.ClientId");  List data =q.getResultList();  return ok(Json.toJson(data));}第一個(gè)pojo@Entitypublic class client_file_configuration {  @Id  @GeneratedValue(strategy = GenerationType.IDENTITY)  private int id;  private String sourceFolder;  private String sourceFile;  private String processingFolder;  private String processingFile;  private String processedFolder;  private int intervalInMin;  private String readAfterDelay;  private String parserClass;  private String directoryMode;  private String fileMode;  private String actionMode;  private String type;  private String fileExpressionResolver;  @OneToOne  @JoinColumn(name = "ClientId")  private client_software_configuration clientSoftwareConfiguration;  public client_software_configuration getClientSoftwareConfiguration() {    return clientSoftwareConfiguration;  }  public void setClientSoftwareConfiguration(client_software_configuration clientSoftwareConfiguration) {    this.clientSoftwareConfiguration = clientSoftwareConfiguration;  }}