This are my tables:
tblData
numIndex | num | cost
tblPrize
numIndex | num | Prize
and the result I want is :
tblData.num=tblPrize.num
then
sum the cost in tblData
example of the table view i want:
tblData.Num | SUM(tblData.cost) | tblPrize.prize