把结果再Join一遍slelect a.username, b.TotalMoney, b.MaxBuyTime from buyer a left join (select buyer.userid, buyer.username, sum(list.buymoney), max(list.buytime) from buyer left outer join list on buyer.userid = list.userid where list.buytime between '2009-9-18' and '2009-9-21' group by buyer.username ) b on a.userid=b.userid order by b.TotalMoney desc
select buyer.username, sum(list.buymoney), max(list.buytime) from buyer left outer join list on buyer.userid = list.userid AND list.buytime between '2009-9-18' and '2009-9-21' group by buyer.username order by list.buymoney desc
from buyer a
left join
(select buyer.userid, buyer.username, sum(list.buymoney), max(list.buytime)
from buyer left outer join list on buyer.userid = list.userid
where list.buytime between '2009-9-18' and '2009-9-21'
group by buyer.username
) b
on a.userid=b.userid
order by b.TotalMoney desc
from buyer left outer join list on buyer.userid = list.userid
AND list.buytime between '2009-9-18' and '2009-9-21'
group by buyer.username
order by list.buymoney desc