表A
字段：
UID PID
1 1
1 2
2 1
3 2
表B
字段：
PID Des
1 'admin '
2 'super '
怎么实现取得UID=1的记录，即：Des既等于 'admin '，又等于 'super '的记录。
我知道用where exists (...where Des=) and exists (...where Des=)可以实现。
可是感觉效率不是很高的。怕数据量大了，速度慢。
那位大哥能给个优化的查询语句啊？谢谢~
(明天结帖)
------解决方案--------------------
declare @ta table(UID int,PID int)
insert @ta
select 1, 1 union all
select 1, 2 union all
select 2, 1 union all
select 3, 2
declare @tb table(PID int,Des varchar(20))
insert @tb
select 1, 'admin ' union all
select 2, 'super '
SELECT UID FROM (select UID from @ta group by UID,PID) as t
group by UID having count(*)=(select count(*) from @tb)
/*
UID
-----------
1
*/
------解决方案--------------------
select distinct uid from @ta a where
not exists
(select * from @tb where pid
not in (select pid from @ta b where a.uid=b.uid ))