56,679
社区成员
发帖
与我相关
我的任务
分享
SELECT
a.id,
IF(f.pay_type==1,f.pay_fund,'') AS 'cash',
IF(f.pay_type==2,f.pay_fund,'') AS 'card',
IF(f.pay_type==3,f.pay_fund,'') AS 'QRcode'
FROM `fund` a
LEFT JOIN (
SELECT
SUM(pay_fund) AS 'pay_fund',
pay_type,
fund_id
FROM `fund_list`
GROUP BY fund_id,pay_type
) f ON f.fund_id = a.id
GROUP BY a.id