暖通空调工程师注册证:以下的多条语句怎样求他们的交集??

来源:百度文库 编辑:查人人中国名人网 时间:2024/05/12 10:27:44
select *
from 还原0511
where client_id not in (select client_id from xtj0503)

select *
from 还原0511
where client_id not in (select client_id from xtj0504)

select *
from 还原0511
where client_id not in (select client_id from xtj0505)

select *
from 还原0511
where client_id not in (select client_id from xtj0506)

select *
from 还原0511
where client_id not in (select client_id from xtj0507)