将两个不同表中的几列乘以多个速率(mysql)

表1-LocTbl

ID Location Inspections ServiceCalls RegularHrs OTHrs
1 LA         1             3            7         2
2 LA         2             4            6         3
3 LA         5             1            8         1

表2-费率

Location RateType      Rate
LA       Inspections    100
LA       ServiceCalls   42
LA       RegularHrs     20
LA       OTHRs          30
SF       Inspections    110
SF       ServiceCalls   45

Location InspectionCost ServiceCallCost RegularHrsCost OTHrsCost TotalCost
LA       800            336             630            120       1886

我需要的是位置表中的每一列总和乘以相应的速率和这些列的总和。类似这样:

SELECT 
Sum(Location.Inspections)*Rates.Rate as InspectionCost, 
Sum(Location.ServiceCalls)*Rates.Rate as ServiceCallCost, 
Sum(Location.RegularHrs)*Rates.Rate as RegularHrsCost, 
Sum(Location.OTHRs)*Rates.Rate as OTHrsCost
[-- >Sum(InspectionCost)+Sum(ServiceCallCost)+Sum(RegularHRsCost)+Sum(OTHrsCost) as TotalCost  <--] 
^ how can I calculate the totals for the columns already multiplied?
FROM Location, Rates
WHERE Rates.Rate = ? {how do I reference all of the corresponding rates?}