下面应该可以 SELECT P.PQMC,SUM(Q.SKJE) FROM PQTABLE P, QBTABLE Q WHERE P.PQID=Q.PQID GROUP BY P.PQMC
加上合计: SELECT P.PQMC,SUM(Q.SKJE) FROM PQTABLE P, QBTABLE Q WHERE P.PQID=Q.PQID GROUP BY P.PQMC union all select '合计',SUM(Q.SKJE) FROM PQTABLE P, QBTABLE Q WHERE P.PQID=Q.PQID
select a.pqmc,b.sjke from paqable a,(select pqid,sum(skje) no from qbtable group by pqid) b where a.pqid=b.pqid union select '合计' pqmc,sum(skje) skje from qbtable;
select a.pqmc,b.sjke from paqable a, ( select pqid,sum(skje) no from qbtable group by pqid ) b where a.pqid=b.pqid union select '合计',sum(skje) from ( select a.pqmc,b.sjke from paqable a, ( select pqid,sum(skje) no from qbtable group by pqid ) b where a.pqid=b.pqid) )
上面错了个字段名select a.pqmc,b.skje from paqable a, ( select pqid,sum(skje) skje from qbtable group by pqid ) b where a.pqid=b.pqid union select '合计',sum(skje) from ( select a.pqmc,b.skje from paqable a, ( select pqid,sum(skje) skje from qbtable group by pqid ) b where a.pqid=b.pqid) )
select PQMC,sum(SKJE) from ( select PQMC,SKJE from PQTABLE,QBTABLE where PQTABLE.PQID=QBTABLE.PQID ) group by PQMC union select '合计',select sum(SKJE) from QBTABLE;
select a.pqmc pqmc, b.skje skje from pqtable a,(select pqid, sum(skje) as skje from qbtable group by pqid) b where b.pqid=a.pqid order by a.pqmc union select "合计",sum(skje) from qbtable
你可以按照这个写法来写。。 Select Nvl(Pqmc, '合计'), Total (Select a.Pqmc Pqmc, Sum(b.Skje) Total From a, b Where a.Pqid = b.Pqid Group By Rollup(a.Pqmc))
少了个from Select Nvl(Pqmc, '合计'), Total From (Select a.Pqmc Pqmc, Sum(b.Skje) Total From a, b Where a.Pqid = b.Pqid Group By Rollup(a.Pqmc))
select a.pqmc sum(b.skje) from patable a, qbtable b where a.pqid=b.pqid group by a.pqmc union all select '合计',sum(a.skje) from pqtable a, qbtable b where a.pqid = b.pqid
SELECT P.PQMC,SUM(Q.SKJE) FROM
PQTABLE P, QBTABLE Q
WHERE P.PQID=Q.PQID
GROUP BY P.PQMC
SELECT P.PQMC,SUM(Q.SKJE) FROM
PQTABLE P, QBTABLE Q
WHERE P.PQID=Q.PQID
GROUP BY P.PQMC
union all
select '合计',SUM(Q.SKJE) FROM
PQTABLE P, QBTABLE Q
WHERE P.PQID=Q.PQID
where a.pqid=b.pqid
union
select '合计' pqmc,sum(skje) skje from qbtable;
from paqable a,
(
select pqid,sum(skje) no
from qbtable group by pqid
) b
where a.pqid=b.pqid
union
select '合计',sum(skje) from
(
select a.pqmc,b.sjke
from paqable a,
(
select pqid,sum(skje) no
from qbtable group by pqid
) b
where a.pqid=b.pqid)
)
from paqable a,
(
select pqid,sum(skje) skje
from qbtable group by pqid
) b
where a.pqid=b.pqid
union
select '合计',sum(skje) from
(
select a.pqmc,b.skje
from paqable a,
(
select pqid,sum(skje) skje
from qbtable group by pqid
) b
where a.pqid=b.pqid)
)
(
select PQMC,SKJE from PQTABLE,QBTABLE
where PQTABLE.PQID=QBTABLE.PQID
)
group by PQMC
union
select '合计',select sum(SKJE) from QBTABLE;
from pqtable a,(select pqid, sum(skje) as skje
from qbtable
group by pqid) b
where b.pqid=a.pqid
order by a.pqmc
union
select "合计",sum(skje)
from qbtable
Select Nvl(Pqmc, '合计'),
Total (Select a.Pqmc Pqmc, Sum(b.Skje) Total
From a, b
Where a.Pqid = b.Pqid
Group By Rollup(a.Pqmc))
From (Select a.Pqmc Pqmc, Sum(b.Skje) Total
From a, b
Where a.Pqid = b.Pqid
Group By Rollup(a.Pqmc))
patable a, qbtable b
where a.pqid=b.pqid
group by a.pqmc
union all
select '合计',sum(a.skje) from
pqtable a, qbtable b
where a.pqid = b.pqid