title: How to make this select * from two joined tables query in HQL form?
body: <p>I had two hibernate entity here with annotation:</p>
  
  <pre><code>@Entity
  @Table(name = "CLIENT")
  public class Client {
  
      private Long pkClient;
      private String name;
  
      @Id
      @GeneratedValue(strategy=GenerationType.AUTO)
      @Column(name="PK_CLIENT")
      public Long getPkClient() {
          return pkClient;
      }
      public void setPkClient(Long pkClient) {
          this.pkClient = pkClient;
      }
  
      @Column(name="NAME")
      public String getName() {
          return name;
      }
      public void setName(String name) {
          this.name = name;
      }
  
      ...
  }
  
  @Entity
  @Table(name="ACCOUNT")
  public class Account {
  
      private Long pkClientAccount;
      private Long fkClient;
      private String accountNo;
  
      @Id
      @Column(name="PK_CLIENT_ACCOUNT")
      @GeneratedValue(strategy=GenerationType.AUTO)
      public Long getPkClientAccount() {
          return pkClientAccount;
      }
      public void setPkClientAccount(Long pkClientAccount) {
          this.pkClientAccount = pkClientAccount;
      }
  
      @Column(name="FK_CLIENT")
      public Long getFkClient() {
          return fkClient;
      }
      public void setFkClient(Long fkClient) {
          this.fkClient = fkClient;
      }
  
      @Column(name="ACCOUNT_NO")
      public String getAccountNo() {
          return accountNo;
      }
      public void setAccountNo(String accountNo) {
          this.accountNo = accountNo;
      }
  
      ...
  }
  </code></pre>
  
  <p>The relationship is one-to-many which a Client has many Account. Table ACCOUNT has foreign key (FK_CLIENT) to table CLIENT's primary key (PK_CLIENT).</p>
  
  <p>I want to perform this query in HQL form:</p>
  
  <pre><code>select * from ACCOUNT a inner join CLIENT b on a.FK_CLIENT = b.PK_CLIENT
  </code></pre>
  
  <p>This mean, all properties from Account and Client entity will be selected.</p>
  
  <p>Anyone know how to make that query in HQL form?</p>
  
  <p>AFAIK, in HQL we can only select one entity.</p>
  
  <p>Note:<br/>
  I cannot use @ManyToOne mapping in Account entity because there is already fkClient property and I can't change this because the get/setFkClient has already been used in other places.</p>
  
  <p>The code above has been simplified by removing unrelated parts to make easier to read. If you find a typo, please let me know in the comment section since I typed the code manually.</p>