SELECT * FROM employees WHERE employee_id NOT IN (SELECT employee_id FROM job_history)
What is all the information about employees who have never had a 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 )
What is all the information about employees who have never had a job in the past ?