<JPQL nested join> I have 3 entities: @Entity @Tab...

# stackoverflow

[rss]

JPQL nested join
I have 3 entities:
@Entity
@Table(name = "users")
data class User(

@Id
var email: String? = null,

@ManyToMany
@JoinTable(
name = "user_roles",
joinColumns = [JoinColumn(name = "USER_ID", referencedColumnName = "EMAIL")],
inverseJoinColumns = [JoinColumn(name = "ROLE_ID", referencedColumnName = "NAME")]
)
var roles: Set? = null

)
@Entity
@Table(name = "roles")
data class Role(

@ManyToMany
@JoinTable(
name =...