作者:mobiledu2502913277 | 来源:互联网 | 2023-05-18 04:23
selecta.customer_id,b.amount_after,b.create_timefrommcc_customer_consumealeftjoinmcc_amoun
select a.customer_id, b.amount_after, b.create_time
from mcc_customer_consume a left join mcc_amount_change_record b on a.customer_id = b.customer_id
left join mcc_customer y on a.customer_id = y.id
where register_date between "2017-04-01 00:00:00" and "2017-05-01 00:00:00"
and amount_after >= "500"
and consume_status = "1"
group by customer_id
having create_time < min(consume_date)
3 个解决方案
你说的不出来结果是啥意思,是语句执行不出来,还是执行了没有数据。没有数据的话多半是你语句写的有问题。你先把Group by 和Having 去掉执行看看有没有数据。有的话就说明下group by和having有问题。或者说是你having的时候把数据全给过滤了