SELECT employee.emp_id,employee.job_id FROM employee LEFT OUTER JOIN jobs ON employee.job_id<>jobs.job_id
SELECT employee.emp_id,employee.job_id FROM employee LEFT OUTER JOIN jobs ON employee.job_id=jobs.job_id
SELECT employee.emp_id,employee.job_id FROM employee LEFT OUTER JOIN jobs ON employee.job_id=jobs.job_id WHERE (jobs.job_id IS NULL)
SELECT employee.emp_id,employee.job_id FROM employee INNER JOIN jobs ON employee.job_id=jobs.job_id WHERE (jobs.job_id IS NULL)
select employee.emp_id, employee.job_id from employee left outer join jobs on employee.job_id = jobs.job_id where employee.job_id is null or employee.job_id <> jobs.job_id
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)