主 题:
这句sql语句可不可以变成连接查询的呢?
作 者:
overmind (overmind)
等 级:
信 誉 值:
100
所属社区:
Oracle 开发
问题点数:
100
回复次数:
6
发表时间:
2004-12-14 10:31:43
select t1.oid from t1 where t1.oid not in (select oid from t2 where t2.userid='overmind');
回复人:
overmind(overmind) ( ) 信誉:100
2004-12-14 10:32:07
得分: 0
谢谢了先!
Top
回复人:
ORARichard(没钱的日子好难过啊) ( ) 信誉:100
2004-12-14 10:38:00
得分: 100
select t1.oid from t1,(select oid from t2 where t2.userid='overmind') t3
where t1.oid <> t3.oid
Top
回复人:
ORARichard(没钱的日子好难过啊) ( ) 信誉:100
2004-12-14 10:40:49
得分: 0
还可以
select t1.oid from t1,
(
select oid from t1
minus
select oid from t2 where userid='overmind'
) t3
where t1.oid=t3.oid;
本文地址:http://com.8s8s.com/it/it19679.htm