join three table

Hello Viral,

 

With help of Joins, you can achieve your desired result. I've written below query to get the same. 

This query will give you the result like below.

 

 

 

I've also added an additional column named "Total Items" this will give you the total item for which the sum or the Total is calculated.

Hope this help you. Please let me know if you need any help on this.

 

Thanks and Regards,

Abhishek Ramjeet Yadav

SQL Server DBA