SQL语句如下:
SELECT unitname, SUM(amount), datatype, defraymode, datasource
FROM (SELECT
(SELECT u.unitname
FROM mm_unit_tc u
WHERE u.unitcode = p.unitcode) unitname,
SUM(amount) amount,
datatype datatype,
defraymode defraymode,
p.datasource datasource
FROM mm_payablemoney_td p
WHERE p.subcompany = v_subcompany
AND p.opstatus IN ('0', '1')
AND p.opdate BETWEEN v_startdate
AND v_enddate
GROUP BY unitcode, defraymode, datatype, datasource
ORDER BY unitcode, defraymode, datatype, datasource)
GROUP BY unitname, defraymode, datatype, datasource