select b.TYPE_NAME SBIGTYPE_NAME, b.TYPE IBIGTYPE_TYPE, a.ID SSMALLTYPE_ID, a.SSMALLTYPE_NAME, a.DPLAN_AMOUNTALL FSMALLTYPE_PALN_AMOUNT, d.actual_amountall FSMALLTYPE_ACTUAL_AMOUNT
from HY_PROJECT_CAPITAL_SMALLTYPES a
left join HY_PROJECT_CAPITAL_BIGTYPE b on a.SBIGTYPE_ID = b.ID
left join (
select c.SSMALL_TYPEID, sum(c.DACTUAL_AMOUNT) actual_amountall from HY_PROJECT_CAPITAL_DETAIL c where c.SPROJECT_ID = #{projectId,jdbcType=VARCHAR} group by c.SSMALL_TYPEID
) d on d.SSMALL_TYPEID = a.ID
order by a.TADD_TIME asc;