wait a sec... the cart isn't actually a table?
sorry, a join will not be possible
loop through your cart, pick up the item_ids, and retrieve the inventory records like this --
SELECT id,price FROM inventory WHERE id IN ( [I]list of ids[/I] )
so basically just like dan said in post #2
then do your array-matching application code voodoo to perform the multiplication