The only issue I see here is with Scott and My results is the emp_id = 45678. The employee has the same email for both fields, and that email is not repeated anywhere else by another employee. That may be a valid email.