Comparing columns in sql

I want to compare two columns in Sql oldname newname empid j11 j12 j12 j13 j13 i want to fetch list of employee who have completed certain certificate lets say emp1 has done j11 cert but later on certificate name changes to j12 so that employee name should come as certified than later on if j12 is changed as j13 still that employee is considered as certified.