create table test (
   id                   int                  identity,
   f_id                 int                  not null,
   f_id3                int                  not null,
   test                 varchar(255)         not null,
   constraint PK_TEST primary key (id)
)
go
create table test2 (
   id2                  int                  identity,
   test2                varchar(255)         not null,
   constraint PK_TEST2 primary key (id2)
)
go
create table test3 (
   id                   int                  identity,
   id3                  int                  not null,
   test3                varchar(255)         not null,
   constraint PK_TEST3 primary key (id)
)
go
create unique index Index_id3 on test3 (
id3 ASC
)
go
alter table test
   add constraint FK_TEST_REFERENCE_TEST2 foreign key (f_id)
      references test2 (id2)
go
alter table test
   add constraint FK_TEST_REFERENCE_TEST3 foreign key (f_id3)
      references test3 (id3)
go
insert into test2 values('test21')
insert into test2 values('test22')
insert into test2 values('test23')

insert into test3 values(9, 'test31')
insert into test3 values(11, 'test32')
insert into test3 values(13, 'test33')

insert into test(f_id, f_id3, test) values(1, 9, 'test11' )
insert into test(f_id, f_id3, test) values(2, 11, 'test12' )
insert into test(f_id, f_id3, test) values(3, 13, 'test13' )
insert into test(f_id, f_id3, test) values(1, 13, 'test13' )
insert into test(f_id, f_id3, test) values(2, 11, 'test12' )
insert into test(f_id, f_id3, test) values(3, 9, 'test11' )

select t.*, t2.*, t3.*
from test t
inner join test2 t2 on t.f_id = t2.id2
inner join test3 t3 on t.f_id3 = t3.id3

@Entity
public class test implements Serializable {
    
   @Id
   @Column(name="id", nullable=false, unique=true)
   private Integer id;
   public Integer getId(){
     return this.id;
   }
   public void setId(Integer id_){
     this.id = id_;
   }
   
    @OneToOne()
    @JoinTable(name="test2",
               joinColumns = @JoinColumn( name="id2"),
               inverseJoinColumns = @JoinColumn( name="f_id"))
    private test2 f_id;
    public test2 getF_id(){
      return this.f_id;
    }
    public void setF_id(test2 f_id_){
      this.f_id = f_id_;
    }
    
    @OneToOne
    @JoinTable(name="test3",
               joinColumns = @JoinColumn( name="id3"),
               inverseJoinColumns = @JoinColumn( name="f_id3"))
    private test3 f_id3;
    public test3 getF_id3(){
      return this.f_id3;
    }
    public void setF_id3(test3 f_id3_){
      this.f_id3 = f_id3_;
    }
    
    @Column(name="test", length=255, nullable=false)
    private String test;
    public String getTest(){
      return this.test;
    }
    public void setTest(String test_){
      this.test = test_;
    }
}

@Entity
public class test2 implements Serializable {
    
   @Id
   @Column(name="id2", nullable=false, unique=true)
   private Integer id2;
   public Integer getId2(){
     return this.id2;
   }
   public void setId2(Integer id2_){
     this.id2 = id2_;
   }
   
   @Column(name="test2", length=255, nullable=false)
   private String test2;
   public String getTest2(){
     return this.test2;
   }
   public void setTest2(String test2_){
     this.test2 = test2_;
   }
}

@Entity
public class test3 implements Serializable {
    
   @Id
   @Column(name="id", nullable=false, unique=true)
   private Integer id;
   public Integer getId(){
     return this.id;
   }
   public void setId(Integer id_){
     this.id = id_;
   }
   
    @Column(name="id3", nullable=false, unique=true)
    private Integer id3;
    public Integer getId3() {
        return id3;
    }
    public void setId3(Integer id3) {
        this.id3 = id3;
    }

    @Column(name="test3", length=255, nullable=false)
    private String test3;
    public String getTest3() {
        return test3;
    }

    public void setTest3(String test3) {
        this.test3 = test3;
    }
}

      private List<test> test_;
      ...
      this.test_ = this.apputil.getSessionMSSQL2().createSQLQuery("select t.*, t2.*, t3.* "
                                                               + " from test t "
                                                               + " inner join test2 t2 on t.f_id = t2.id2"
                                                               + " inner join test3 t3 on t.f_id3 = t3.id3")
                            .addEntity("t", test.class)
                            .addJoin("t2", "t.f_id")
                            .addJoin("t3", "t.f_id3")
                            .list();

Caused by: org.hibernate.AnnotationException: @OneToOne or @ManyToOne on request.bean.test.f_id3 references an unknown entity: request.bean.test3

Caused by: org.hibernate.ObjectNotFoundException: No row with the given identifier exists: [request.bean.test3#9]

Результат запроса такой, что ему не нравится

id	fid	fid3	test	id2	test2	id	id3	test3
1	1	9	test11	1	test21	1	9	test31
2	2	11	test12	2	test22	2	11	test32
3	3	13	test13	3	test23	3	13	test33
4	1	13	test13	1	test21	3	13	test33
5	2	11	test12	2	test22	2	11	test32
6	3	9	test11	3	test23	1	9	test31

@Entity
public class test implements Serializable {
...
    @OneToOne
    @JoinTable(name="test3",
               joinColumns = @JoinColumn( name="id3"),
               inverseJoinColumns = @JoinColumn( name="f_id3"))
    private test3 f_id3;
    public test3 getF_id3(){
      return this.f_id3;
    }
    public void setF_id3(test3 f_id3_){
      this.f_id3 = f_id3_;
    }