select a.user_name,a.count1,b.count2 from
(select user_name,count(*) count1 from tab1 group by user_name) a join
(select user_name,count(*) count2 from tab2 group by user_name) b on a.user_name=b.user_name
(select user_name,count(*) count1 from tab1 group by user_name) a join
(select user_name,count(*) count2 from tab2 group by user_name) b on a.user_name=b.user_name
解决方案 »
- pl/sql developer如何用Database links建立连接
- pl\sql developer无法登陆
- oracle数据库中有10个表,这10个表很相似,如果把这10个表合成一个表?存储过程
- 在一个表中如何重复统计多个字段
- 关于pl/sql中的jobs的用法
- Oracle登陆问题,请赐教
- /bdump/*.trc 问题
- 初学ORACLE两个简单问题,
- 求Delphi连接Linux下的Oracle 9.i方法.
- 麻烦大侠们帮我看一下这样实现的效率会怎样,谢谢!!
- 能否不卸载ORACLE92标准版,直接升级到企业版,如何操作?
- 如何将一个DMP文件导入9i数据库呢,自己建的数据库实例的表空间一定要和DMP里面的表空间一致吗?
from
(select user_name,count(*) count1 from tab1 group by user_name) a ,
(select c.user_name,nvl(b.count2,0,b.count2) as count2
from tab1 c,
(select user_name,count(*) count2
from tab2
group by user_name) b
where c.user_name=b.user_name(+)) a2
where a.user_name=a2.user_name