Spring data jpa INNER JOIN

 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();