jpa 联合查询方法

public interface TaskBaseline {
    String getNumber();

    String getTitle();

    String getName();

    String getProject();

    String getTest();
    //Integer  getTaskbaselineid();
}
@Query(nativeQuery = true,value = "select t.number as number, t.title as title, b.name as name ,b.project as project,tb.test as test from task t, baseline b, task_baseline tb where t.id=tb.taskid and b.id=tb.baselineid ")
    Iterable<TaskBaseline> findAllJonin();

 

posted @ 2019-01-25 16:13  cnchengv  阅读(272)  评论(0编辑  收藏  举报