wangledahai 发表于 2008-07-28 08:05

oracle to ase

对于 select * from t1
         union
         select * from t2
          minus
SELECT * FROMt3

各位有没有什么好的解决办法呢？谢谢了！

chuxu 发表于 2008-07-28 09:02

select * from(
select * from T1
union select * from T2
) as T_v where not exist (select 1 from T3
where T_v.id1=T3.id1 and T_v.id2=T3.id2 ....)

wangledahai 发表于 2008-07-28 09:24

原帖由 chuxu 于 2008-7-28 09:02 发表 http://bbs.chinaunix.net/images/common/back.gif
select * from(
select * from T1
union select * from T2
) as T_v where not exist (select 1 from T3
where T_v.id1=T3.id1 and T_v.id2=T3.id2 ....)


谢谢 ！
页: [1]
查看完整版本: oracle to ase