oracle两个表中数据匹配,通过SQL查找两张表中不匹配的行

--创建测试数据

create table employees_act as

select employee_id,first_name,last_name from hr.employees where employee_id in(102,105,112,118,119,205) order by employee_id;

create table employees_new as

select employee_id,first_name,last_name from hr.employees where employee_id in(101,105,112,171,201) order by employee_id;

SQL> select * from employees_new;

EMPLOYEE_ID FIRST_NAME           LAST_NAME

----------- -------------------- -------------------------

101 Neena                Kochhar

105 David                Austin

112 Jose Manuel          Urman

171 William              Smith

201 Michael              Hartstein

SQL> select * from employees_act;

EMPLOYEE_ID FIRST_NAME           LAST_NAME

----------- -------------------- -------------------------

102 Lex                  De Haan

105 David