助人为乐 回复 迷人魔男相川步(提问者)select ${if(p1=\"1\",\",sum(AMOUNT1)\",\"\")}
${if(p1=\"2\",\",sum(AMOUNT2)\",\"\")} from 表
select expense_year, ${if(p1=\"1\",\"sum(amount_money)\",\"\")}
${if(p1=\"2\",\"sum(product_income_cost)\",\"\")} from表
group by expense_year