SELECT users_checkin.* FROM users_checkin INNER JOIN users_profile ON users_checkin.emp_id=users_profile.emp_id GROUP BY users_checkin.emp_id