SQL Server Join and Sum Tables

Question

I have 2 tables, table A:

CategoryId | Qty

1 | 10
2 | 15

Table B:

SaleId | CategoryId | QtyReserved

1 | 1 | 2
2 | 1 | 1
3 | 2 | 5

I want to display result like this (joining both tables):

CategoryId | Qty | QtyReserved

1 | 10 | 3 ---> sum records (column QtyReserved) from table B
2 | 15 | 5

How can I possibly achieve this? Thank you.

hint... SUM ... GROUP BY...

Abdul Rasheed
– Abdul Rasheed

2018-11-02 11:03:22 +00:00
Commented Nov 2, 2018 at 11:03 — Abdul Rasheed
– Abdul Rasheed, Commented Nov 2, 2018 at 11:03

Abdul Rasheed · Accepted Answer · 2018-11-02 11:05:41Z

2

use SUM and GROYP BY

SELECT  C.CategoryId,C.Qty,SUM(S.QtyReserved) AS QtyReserved
FROM    tableA AS C
INNER JOIN tableB AS S ON C.CategoryId = S.CategoryId
GROUP BY C.CategoryId,C.Qty

answered Nov 2, 2018 at 11:05

Abdul Rasheed

6,7794 gold badges36 silver badges50 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL Server Join and Sum Tables

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related