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