@JimChen 不是 SELECT
a.,
IFNULL((SELECT SUM(is_out) FROM loan_repay_plan AS b WHERE a.loan_no = b.loan_no AND b.status = 3 ),0) AS sum_is_out
FROMloan_repay_plan
AS a where a.status =3 GROUP BY a.loan_no,a.status
UNION ALL
SELECT
, is_out
AS sum_is_out
FROMloan_repay_plan
where status =2 类似这个sql 但是我这样处理很费劲
@JimChen 表a
id money loan_no status
1 2000。 1234 2
2。 3000 1234 3
3。 3000。 1234 2
select * from a where status in (2,3) 这样获取的是所有状态为 2 3的 需求是 id1和3 数据需要根据loan_no相同合并为一条 数据金额相加 为 5000元
@JimChen 不是 SELECT
a.,
IFNULL((SELECT SUM(is_out) FROM loan_repay_plan AS b WHERE a.loan_no = b.loan_no AND b.status = 3 ),0) AS sum_is_out
FROMloan_repay_plan
AS a where a.status =3 GROUP BY a.loan_no,a.status
UNION ALL
SELECT
, is_out
AS sum_is_out
FROMloan_repay_plan
where status =2 类似这个sql 但是我这样处理很费劲
推荐文章: