How to sumarize from one table field and devide the result from other table field caunting.
Hello! I have a big problem. I can't find thecorrect solution for my problem. I have 2 tables: one is Claims table and second is Bus_Truck_Sale table. The key field in Claims table should be "ChassiNo" and in Bus_Truck_Sale table - "VIN". I need to make graph Costs per one Vehicle it means: I should make SUM(AATotalCosts) from table Claims devide it COUNT(DISTINCT VIN) from table Bus_Truck_Sale in 12 months back period. The couted vehicles must not be older 12 months in this period. Some vehicles are in bouth tables some not, but when I couting vehicles I should in clude vehicle which don't have any claims but it sold in this period.
