How to display columns from two tables in Vaadin Grid (inner join)?

Question

Java

Let's say I have two entities: a loan and a bank employee. It is necessary to display information on the loan, as well as the name of the employee who issued it through Foreign Key. That is, the query is something like this:
select C.ID, C.DATE, E.FIRST_NAME, E.LAST_NAME from CREDIT C
inner join EMPLOYEE E on C.EMPLOYEE_ID = E.ID
Vaadin Grid supports mapping of an already defined class. How can I display a structure containing data from multiple tables?

Answer 1

Do you have this relationship defined at the entity level?