join three table

Question

Table 1 : Category CID (PK) CNAME Table 2 : Product PID (PK) CID (FK) PNAME Table 3 : Price ID (PK) PID (FK) Price I have to sum of price and display CNAMEPNAME and Total of Price Output: CNAME PNAME Total Category1 Product1 500 (Sum of Total Related with PID (FK)).

Abhishek Yadav · Answer

Hello Viral With help of Joins you can achieve your desired result. I've written below query to get the same. Select c.CName pd.PName count (p.PID) as [Total Item] sum (p.Price) as [Total] from Category c join Product pd on pd.CID = c.CID join Price p on p.PID = pd.PID group by c.CName pd.PName p.PID 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

Ananth G · Answer

select a.CNAMEb.PNAME d.TotalPrice from Category a left join Product b on a.CID =b.CID left join ( select c.PID as PID sum (c.Price) as TotalPrice from Price c group by c.PID) as d on b.PID =d.PID use this query If this answer is correct then accept the answer