---

SELECT e.id_worker, CONCAT(e.surname_worker,' ',e.name_worker,' ',e.patronymic_worker) AS fio, eh.number_doc, eh.date_doc FROM employees e LEFT JOIN list_team lt ON e.id_worker = lt.id_employee LEFT JOIN employment_history eh ON e.id_worker = eh.id_employee WHERE lt.id_employee IS NULL AND eh.type_recodr = 'Прием'