I have two databases wich include 3 tables each,Employees, Courses Attended and Courses, one for current employees and their training records and the other is for employees that have left, which also shows the courses they did.
When an employee leaves I would like to append that record from one...