高手请进,一个简单的问题!!! select a.* from a where not exists(select 1 from b where b.id=a.id); 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select * from A where id no in (select id from B where A.id=B.id) sorryselect * from A where id not in (select id from B where A.id=B.id) select * from from a where a.id not in (select id from b); select a.id from (select a.id,b.id from a,b where a.id = b.id(+))where b.id is null; select a.id from (select a.id,b.id from a,b where a.id = b.id(+))where b.id is null; select a.*from a,bwhere a.id = b.id(+) and b.id is null 在charindex()函数在oracle中怎么用? 求救: 今天误操作,把一个数据库删除了。 急问,pro*c调用的存储过程不执行,why?请指点! 请教高手,将Oracle数据导出,再导入到postgre数据库中 请帮忙写个触发器,谢谢了 -1 !送上110分(另外10分在下贴白送) 我是个菜鸟,问数据库备份的问题 Sql Server 與 Oracle 比較(store procedure) 创建一个用户 如何导出表中的数据 用过oracle个人版的请进,简单问题,急急急!! 如何将文本文件导入oracle ORACLE的存储过程中能读写文件吗?
where a.id not in (select id from b);
where b.id is null;
where b.id is null;
from a,b
where a.id = b.id(+)
and b.id is null