I'm using Oracle 10g, and I'm trying to select rows from one table that do not appear in the other table in the query using a set operator.
I'm trying to select
SELECT id, last_name, first_name FROM employees
SELECT id, TO_CHAR(null), TO_CHAR(null) FROM job_history;
SELECT id FROM employees
SELECT id FROM job_history;
You can use a inner join on the select result
select a.id, a.last_name, a.first_name from employees a inner join ( SELECT id FROM employees MINUS SELECT id FROM job_history ) x on x.id = a.id