|
1、select a.xkkh,count(b.xh) yxrs from ryxkjxrwb a,ryxxkxsxkb b,xxmc c where a.xn=b.xn(+) and a.xq=b.xq(+) and a.xkkh=b.xkkh(+) and a.xn=c.xkxn and a.xq=c.xkxq group by a.xkkh; 2、select a.xkkh,count(*) yxrs from ryxkjxrwb a,ryxxkxsxkb b,xxmc c where a.xn=b.xn(+) and a.xq=b.xq(+) and a.xkkh=b.xkkh(+) and a.xn=c.xkxn and a.xq=c.xkxq group by a.xkkh; |
|
|
|
神啊,救我啊!
|
|