Join Two Tables and calculate SUM of Column in SQL Server

Hi ada20...

select distinct Categorie,sum(C_Suma) from Cheltuieli

There is no table called Cheltuieli.

You have mentioned only 2 tables ie.Invoices and Costs

Cheltuieli means Costs. 

Hi ada20,

Refer below sample query.

SQL

DECLARE @Invoices AS TABLE(category VARCHAR(MAX),due_date DATETIME, [sum] INT)
INSERT INTO @Invoices VALUES('Stationary accessories','2019/08/16',1250)
INSERT INTO @Invoices VALUES('Grocery ingredients','2019/08/17',5000)
INSERT INTO @Invoices VALUES('Electronic accessories','2019/08/18',2000)
INSERT INTO @Invoices VALUES('beautician accessories','2019/08/19',2000)
DECLARE @Costs AS TABLE(category VARCHAR(MAX),[date] DATETIME, [sum] INT)
INSERT INTO @Costs VALUES('Stationary accessories','2019/08/16',1250)
INSERT INTO @Costs VALUES('Grocery ingredients','2019/08/17',2000)
INSERT INTO @Costs VALUES('Electronic accessories','2019/08/18',2000)
INSERT INTO @Costs VALUES('beautician accessories','2019/08/19',2000)

SELECT i.category, SUM(i.[sum]) + SUM(c.[sum]) Suma, c.[date]
FROM @Invoices i
INNER JOIN @Costs c ON c.category = i.category
WHERE DATENAME(MONTH,c.[date])='August'
GROUP BY i.category,c.[date]

Output