I have two tables:

- Employees
id|name
1.|Peter
2.|Andre
3.|Vincent

- Departments
id|department|employee
1 finance | 2
2 sales | 1

I am looking for a query that results the table Departments to show the actual name of the employee instead of a number by using the number (id).

Please help