Edit Question - KnowledgeHub

Title Body

I would like to make a Join query using Jpa repository with annotation @Query. I have two tables: table user with iduser,user_name and: table area with idarea, area_name and iduser The native query is: SELECT u.user_name FROM user as u INNER JOIN area as a ON a.iduser = u.iduser WHERE a.idarea = 4 Now I have a Table Hibernate entity User and Area So I tried with UserRespository @Query(SELECT u.userName FROM User u INNER JOIN Area a ON a.idUser = u.idUser WHERE a.idArea = :idArea) List<User> findByIdarea(@Param("idArea") Long idArea); The Log says: unexpected token: Any Idea, please? My table Entity #User Table @Entity @Table(name="user") public class User implements Serializable { private static final long serialVersionUID = 1L; private Long idUser; private String userName; @Id @GeneratedValue(strategy=GenerationType.AUTO) @Column(name="iduser") public Long getIdUser() { return idUser; } public void setIdUser(Long idUser) { this.idUser = idUser; } @Column(name="user_name") public String getUserName() { return userName; } public void setUserName(String userName) { this.userName = userName; } } #AREA table @Entity @Table(name="area") public class Area implements Serializable { private static final long serialVersionUID = 1L; private Long idArea; private String areaName; private Long idUser; @Id @GeneratedValue(strategy=GenerationType.AUTO) @Column(name="idarea") public Long getIdArea() { return idArea; } public void setIdArea(Long idArea) { this.idArea = idArea; } @Column(name="area_name") public String getAreaName() { return areaName;

Tags (comma-separated) Cancel