orcale 查找出两个表中相同字段的不同的值minus

1.user表
SELECT  user_id FROM OA_COMPANY_USER

2.项目表中投入过的人员

SELECT  DISTINCT  a.USER_ID FROM  OA_COMPANY_USER a, OA_PM_PERSON_INPUT b WHERE a.user_id=b.user_id

3.除了投入过的人员都要

SELECT a.user_id FROM OA_COMPANY_USER a
MINUS
SELECT b.user_id FROM OA_PM_PERSON_INPUT b where b.USER_ID is not null
UNION ALL
(SELECT b.user_id FROM OA_PM_PERSON_INPUT b where b.user_id is not null
 MINUS
 SELECT a.user_id FROM OA_COMPANY_USER a)