Brasciole Brasciole - 1 year ago 114
SQL Question

SUM of multiple products

I'm really struggling with this one. SO I have 2 tables:

  • Products

  • PendingCartItems

Here's a screenshot of structure for both tables:



I need to get the SUM for all 3 products
WHERE pending_cart_id = 18

SELECT SUM(price) as TotalCartPrice FROM products WHERE id = '274'

How can I write it so it sums all 3 id's (274+251+49)?

Answer Source

Would something like this not work?

Select sum(b.price*a.quantity)
  from pending_cart_items a
  join products b
 where a.pending_cart_id =18 

Edit: Just realized I'd omitted the quantity from the cart computation :)

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download