inner join query

mySQL로 쿼리문을 짠 후에 JPQL로 바꿨다.

select * from project as p
		join project_interest_relation as pir
        on p.prj_id = pir.prj_id
        where pir.in_id = 0;

 

    @Query(value = "select p from Project as p join ProjectInterestRelation as pir" +
            " on p.prjId=pir.project.prjId where pir.interest.inId = :interestId")
    List<Project> findByInterest(@Param("interestId") int interestId);

테스트 해본 결과 잘 작동된다!