Jump to content

Lucas3677

New Members
  • Posts

    1
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

Lucas3677's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. I have 3 tables: member_items id (not important), item_id (= items.id), owner_id (= members.id), amount items id, name, price members id, username What I am trying to do here is add up all of a users item values (amount * price) and sort users accordingly from most assets to least. I have started the query, but I don't really know where to go from here. At this point, it doesnt add all the items together, it just gets the last item found for each user SELECT member_items.amount * items.price AS TOTAL, member_items.owner_id FROM member_items LEFT JOIN items ON member_items.item_id = items.id WHERE member_items.amount > 0 GROUP BY member_items.owner_id; Thanks in advance.
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.