Forums - C# Corner

Forum guidelines
viral patel

viral patel

  • 1.4k
  • 32
  • 1.4k

join three table

Dec 17 2016 5:33 AM
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)).
 

Answers (2)