select t.id,tc.create_date replenishmentTime,group_concat(tc.amount) "补录金额",group_concat(tc.create_date) "补录时间"
from t_order t
LEFT JOIN t_charge_supplement tc on t.id=tc.order_id
where t.id="OD190902156712964"
两个表关联查询时,结果正常
加一个表关联并且条件相同
select t.id,tc.create_date replenishmentTime,group_concat(tc.amount) “补录金额”,group_concat(tc.create_date) “补录时间”
from t_order t
LEFT JOIN t_charge_supplement tc on t.id=tc.order_id
LEFT JOIN t_transaction tr on tc.order_id= tr.order_id
where t.id=“OD190902156712964”
结果出现重复,暂未解决。