消費金額:金額
客戶公司編號:CompID
客戶公司名稱:CompNM
Sql語句:
select C.CompNM，sum(A . Amt)from A . CusID = B . CusID left join C on C . CompID = B . CompID group by C . com pnm order by C . com pnm
結束