sum
SELECT
sum(c.account_receivable) - IF(SUM(c.suppliers_money) is null,0,SUM(c.suppliers_money)) AS income_money
FROM
biz_asset_sec_info a,
biz_asset_sec_mapping b,
biz_pay_comfirm_info c
WHERE
a.uuid = b.asset_sec_id
AND b.biz_id = c.uuid
AND a.sys_status = 1
AND b.sys_status = 1
AND c.sys_status = 1
AND a.uuid = '2683ddd334894cedb77f00e3697212d7' ;
sum(c.account_receivable) - IF(SUM(c.suppliers_money) is null,0,SUM(c.suppliers_money)) AS income_money
FROM
biz_asset_sec_info a,
biz_asset_sec_mapping b,
biz_pay_comfirm_info c
WHERE
a.uuid = b.asset_sec_id
AND b.biz_id = c.uuid
AND a.sys_status = 1
AND b.sys_status = 1
AND c.sys_status = 1
AND a.uuid = '2683ddd334894cedb77f00e3697212d7' ;
![](https://img2018.cnblogs.com/blog/1256867/201908/1256867-20190813105550930-2121203771.png)