SQL Query and Simple ADD maths

[jacko_162]

Wonder if someone can help me out:

 

i have 3 Tables (kill, Item_dropped, item_price)

 

what i am trying to do is calculate the price of items that have dropped from each individual kill.

 

so the kill_dropped looks like:

 

itd_kll_id 	itd_itm_id 	itd_quantity
7926 		2476 		3
7926 		23563 		5
7924 		31892 		1
7924 		21640 		3
7924 		2488 		2 

 

then the item_price will be like:

 

id 	price
2476 		300 
23563 		5000
31892 		14500
21640 		12000
2488 		5650 

 

so i need the query to relate to the following:

 

SELECT all prices where itd_kll_id = 7924 and add them up to give me a total.

 

can anyone help me out?

 

i forgot to mention there is a quantity row to encounter also.

[Psycho]

<< Moving to MySQL forum >>

 

SELECT SUM(kd.itd_quantity * ip.price) as total

FROM item_price AS ip
JOIN kill_dropped AS kd
    ON kd.itd_itm_id = ip.id

WHERE kd.itd_kll_id = 7926