Witam, Mam problem ze Spring data jpa, mianowicie chciałbym pobrać zawartość dwóch tabel poprzez INNER JOIN. Czy ktoś wie jak takie coś można osiągnąć ?
public class Employee {
@Id
@NotNull
@Column(name="id_employee")
private int id_employee;
@NotNull
@Column(name="mail" , unique = true)
private String mail;
@ManyToOne(cascade = {CascadeType.ALL})
@JoinColumn(name="team")
private Team team;
public class Team {
@Id
@NotNull
@Column(name="id_team")
private int id_team;
@NotNull
@Column(name="name" , unique = true)
private String name;
@OneToMany(mappedBy="team")
private List<Employee> employees = new ArrayList<>();
public interface EmployeeRepository extends JpaRepository<Employee, Integer> {
@Query("SELECT e.id_employee , e.mail , e.team FROM employee e INNER JOIN team t ON e.team = t.id_team ORDER BY e.id_employee ASC")
List<Employee> findAllOrderByIdAsc();
public class Contraller
List <Employee> list = employeeRepository.findAllOrderByIdAsc();