SELECT * FROM employees WHERE employee_id NOT IN (SELECT employee_id FROM job_history)
display all the information of those employees who did not have any job in the past.
SELECT * FROM employees WHERE employee_id NOT IN ( SELECT employee_id FROM job_history )
select * from employees where employee_id not in ( select employee_id from job_history )
display all the information of those employees who did not have any job in the past .