select A.zgr,count(zgr) count1,B.count2
from
qy_nsrxx A,
(select qy_sbqk.nsrsbh,count(qy_sbqk.nsrsbh) count2 from qy_sbqk group by qy_sbqk.nsrsbh) B
where
A.nsrxx = B.nsrxx(+)
group by A.zgr
from
qy_nsrxx A,
(select qy_sbqk.nsrsbh,count(qy_sbqk.nsrsbh) count2 from qy_sbqk group by qy_sbqk.nsrsbh) B
where
A.nsrxx = B.nsrxx(+)
group by A.zgr
select A.zgr,count(zgr) count1,sum(B.count2) count2
from
qy_nsrxx A,
(select qy_sbqk.nsrsbh,count(qy_sbqk.nsrsbh) count2 from qy_sbqk group by qy_sbqk.nsrsbh) B
where
A.nsrxx = B.nsrxx(+)
group by A.zgr
表qy_nsrxx
zgr nsrsbh .......
1 3701
1 3702
2 3703
2 3704表qy_sbqk
nsrsbh .......
3701
3702
3703类似的数据
我想要的结果是
zgr count1 count2
1 2 2
2 1 2
from
qy_nsrxx A,
(select qy_sbqk.nsrsbh,count(qy_sbqk.nsrsbh) count2 from qy_sbqk group by qy_sbqk.nsrsbh) B
where
A.nsrsbh = B.nsrsbh(+)
group by A.zgr以上sql的结果是:zgr count1 count2
1 2 2
2 2 1这次我认为应该对了:)