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 CNAME,PNAME and Total of Price

 

Output:

  CNAME           PNAME   Total 

  Category1       Product1   500 (Sum of Total Related with PID (FK)).