有很多方法的: select number,name,sum(orderamount) as totalorderamount from tblorder group by number,nameselect view1.*, tblorder,name from (select number,sum(orderamount) as totalorderamount from tblorder group by number) view1 left join on view.number=tblorder.number
select number,name,sum(orderamount) as totalorderamount from tblorder group by number,nameselect view1.*, tblorder,name from (select number,sum(orderamount) as totalorderamount from tblorder group by number) view1 left join on view.number=tblorder.number