暂无个人描述~
最佳答案
select u.id as user_id,u.username,min(o.created_at) as first_created_at,max(o.created_at) as last_created_at
from user u
left join order o on o.user_id=u.id
group by u.id 讨论数量:
select u.id as user_id,u.username,min(o.created_at) as first_created_at,max(o.created_at) as last_created_at
from user u
left join order o on o.user_id=u.id
group by u.id
关于 LearnKu
粤公网安备 44030502004330号
推荐文章：