I have an Employee table with these columns :
- EmployeeId
- Fullname
- Phone
- Department
- Team
- Function
- Manager
and EmployeeHistory containing the history with different columns, but there are some in common :
- EmployeeId
- Fullname
- Email
- Geolocation
- Department
- Team
- Function
- Manager
How can I union them?