Currently I am doing a shopping cart and I need to make use of inner join statement to display the details.

However my table is in the form of inner join.

The two database that I make use of is called:
shoppingcartitems
Products
I link them together by using the productId

My shoppingcartitems attributes are:
SCId
UserId
ProductId
Quantity

My products attributes are:
ProductId
ProdName
ProdColor
ProdDesc
UnitPrice
Quantity
ProdCatId
UserId
ProdImage

The shopping cart will display ProdImage, UnitPrice, ProductName, quantity and TotalPrice(But i dont know how to write the sql statement that sum the unit price from the database)

Thanks

select my,column,list, shoppingcartitems.Quantity * Products.UnitPrice as itemCost from my table
join.....


ofcourse you could just do the calcualtion in the front end.. y'don't have to do it in the query if you don't weant to.