这样的SQL语句应当怎么写。。

[BigRobin]

一个表结构如下(T_USER)：
USERID AS LONG
DEPT AS LONG
如有内容:
USERID DEPT
1 101
1 102
2 101
3 102
现在要选择出DEPT既具有101又具有102的USERID ,
应当怎么写SQL语句?

[bamyl]

SELECT t_user.userid, t_user.dept, t_user_1.dept
FROM t_user INNER JOIN t_user AS t_user_1 ON t_user.userid = t_user_1.userid
WHERE (((t_user.dept)=101) AND ((t_user_1.dept)=102));

[zzssyyvc]

select distinct userid from t_user where dept=101 and userid in (select userid from t_user where dept=102)

[akala]

zzssyyvc是对的，怎么没给分

[ezwyj]

SELECT t_user.userid
FROM t_user
WHERE t_user.dept=101 OR t_user.dept=102;

[masterkey]

select UserId from T_User where Dept in('101','102')

[masterkey]

select distinct UserId from T_User where Dept in('101','102')