Joining 3 tables to get the monthly reports based on different customers

Question

I have 3 tables .

1.Customers Table(CustomerID,CustomerName)
2.SalesTable(SalesChannel,CustoemrID,SalesID)
3.TransactionTable(SalesID,UnitsSold,TotalAmount,SellingDate)

Now i need the Total units sold and total amount for every month of each customer? Please help me with this situation?

possible duplicate of [SQL JOIN and different types of JOINs](http://stackoverflow.com/questions/17946221/sql-join-and-different-types-of-joins) — Tab Alleman, Aug 17 '15 at 16:19

score 0 · Answer 1 · answered Aug 17 '15 at 14:39

SELECT C.CustomerID
      ,C.CustomerName
      ,MONTH(t.SellingDate) AS SalesMonth
      ,SUM(t.UnitsSold * t.TotalAmount) AS TotalSales
FROM       Customers C 
INNER JOIN SalesTable S       ON S.CustomerID = C.CustomerID
INNER JOIN TransactionTable t ON t.SalesID = S.SalesID
GROUP BY C.CustomerID ,C.CustomerName ,MONTH(t.SellingDate)

Joining 3 tables to get the monthly reports based on different customers

1 Answers1