3,491
社区成员
发帖
与我相关
我的任务
分享
with t1 as
(
select 'zhangsan' c1 from dual
union all
select 'lisi' c1 from dual
union all
select 'wangwu' c1 from dual
union all
select 'houliu' c1 from dual
),t2 as
(
select 'zhangsan' c2 from dual
union all
select 'wangwu' c2 from dual
union all
select 'zhaoliu' c2 from dual
)
select c1
from
(
select c1,c2
from t1 left join t2 on c1 = c2
)
where c2 is null
c1
----------------------
1 houliu
2 lisi