SELECT COUNT(*),SUM(应交金额) FROM A
WHERE 应交金额>0 AND 日期>=TO_DATE('2003-01-01','YYYY-MM-DD')
union (all)
SELECT COUNT(*),SUM(支取金额) FROM B
WHERE 日期>=TO_DATE('2003-01-01','YYYY-MM-DD');
WHERE 应交金额>0 AND 日期>=TO_DATE('2003-01-01','YYYY-MM-DD')
union (all)
SELECT COUNT(*),SUM(支取金额) FROM B
WHERE 日期>=TO_DATE('2003-01-01','YYYY-MM-DD');
WHERE 应交金额>0 AND 日期>=TO_DATE('2003-01-01','YYYY-MM-DD'));
(SELECT COUNT(*),SUM(支取金额) FROM B
WHERE 日期>=TO_DATE('2003-01-01','YYYY-MM-DD'));
你的不行吧?
(SELECT COUNT(*),SUM(应交金额) FROM A
WHERE 应交金额>0 AND 日期>=TO_DATE('2003-01-01','YYYY-MM-DD')),
(SELECT COUNT(*),SUM(支取金额) FROM B
WHERE 日期>=TO_DATE('2003-01-01','YYYY-MM-DD'));
bzszp(SongZip)斑竹的我还没看明白!
(SELECT COUNT(*) aa,SUM(应交金额) bb
FROM A WHERE 应交金额>0 AND 日期>=TO_DATE('2003-01-01','YYYY-MM-DD')) tab1,
(SELECT COUNT(*) cc,SUM(支取金额) dd
FROM B WHERE 日期>=TO_DATE('2003-01-01','YYYY-MM-DD') tab2;
16:38:36 SQL> select * from tcn;AAA BBB
---------- ---------
a 1
a 3
a 5
a 6
a 4实际:70
16:52:35 SQL> select * from tcc;AAA BBB
-------------------- ----------
test ip 1.1.1.1 kk C
dd'ddd'dddd
A C
A VB
A SQL
B JAVA
B PHP已选择7行。实际:100
16:52:39 SQL> select * from (
16:52:46 2 select count(*),sum(bbb) from tcn)
16:53:06 3 ,(select count(*) from tcc)
16:53:19 4 ; COUNT(*) SUM(BBB) COUNT(*)
--------- --------- ---------
5 19 7实际:50
16:53:20 SQL>
THANK YOU!
THANK YOU!谢谢各位,结贴!