给你改了一下:
select b.NAME,sum(a.FEE) OPER_FEESUM from TBUSI_EXCHANGE a,TOPER_INFO b where b.BUSI_ID=a.SERIAL_NUMBER group by b.NAME;
select b.NAME,sum(a.FEE) OPER_FEESUM from TBUSI_EXCHANGE a,TOPER_INFO b where b.BUSI_ID=a.SERIAL_NUMBER group by b.NAME;
from TBUSI_EXCHANGE,TOPER_INFO
where TOPER_INFO.BUSI_ID=TBUSI_EXCHANGE.SERIAL_NUMBER(+)
group by TOPER_INFO.ID,TOPER_INFO.NAME;
from TBUSI_EXCHANGE,TOPER_INFO
where TOPER_INFO.BUSI_ID=TBUSI_EXCHANGE.SERIAL_NUMBER(+)
group by TOPER_INFO.ID,TOPER_INFO.NAME;