SELECT
DISTINCT
t1.key
FROM
t1
WHERE
t1.value in
(
SELECT
t2.value
FROM
t2
)
select distinct key from t1 where key not in (select key from t1 a
where not exists(select 1 from t2 where value=a.value)
)
select distinct key from t1 a
where not exists(select 1 from t2 where value<>a.value)
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024