1、按客户统计
select 0 aa,T_Customer.CustomerID,T_Customer.CustomerName a1 , CustomerName, ' ' ModelName,sum(BorrowNumber) as BorrowNumber
from T_BorrowRecord INNER JOIN T_Customer ON T_BorrowRecord.CustomerID = T_Customer.CustomerID
INNER JOIN T_Model ON T_BorrowRecord.ModelID = T_Model.ModelID
group by T_Customer.CustomerID,CustomerName
union all
select 1 aa,T_Customer.CustomerID a1 ,T_Customer.CustomerName,' ' CustomerName, ModelName,sum(BorrowNumber) as BorrowNumber
from T_BorrowRecord INNER JOIN T_Customer ON T_BorrowRecord.CustomerID = T_Customer.CustomerID
INNER JOIN T_Model ON T_BorrowRecord.ModelID = T_Model.ModelID
group by T_Customer.CustomerID,T_Customer.CustomerName,ModelName
order by T_Customer.CustomerID,aa
2、按样机统计
select 0 aa,T_Model.ModelID,ModelName a1, ModelName,'' CustomerName,sum(BorrowNumber) as BorrowNumber
from T_BorrowRecord INNER JOIN T_Customer ON T_BorrowRecord.CustomerID = T_Customer.CustomerID
INNER JOIN T_Model ON T_BorrowRecord.ModelID = T_Model.ModelID
group by T_Model.ModelID,ModelName
union all
select 1 aa,T_Model.ModelID,ModelName a1, '' ModelName, CustomerName,sum(BorrowNumber) as BorrowNumber
from T_BorrowRecord INNER JOIN T_Customer ON T_BorrowRecord.CustomerID = T_Customer.CustomerID
INNER JOIN T_Model ON T_BorrowRecord.ModelID = T_Model.ModelID
group by T_Model.ModelID,ModelName,CustomerName
order by T_Model.ModelID,aa