MySQL Forums
Forum List  »  Newbie

Re: Need help on query which show total sum of result incorrect
Posted by: zell dsf
Date: November 29, 2017 12:16AM

This is the sample query, i am working on. http://sqlfiddle.com/#!9/e6922f/6

I am trying to sum the quantity of product being ordered. It gives me wrong output which caused by the same cart id is used in different orders. I just want to get the query to work to show correct output.

The expected result should be

1, 1, 1 for each product id.

Options: ReplyQuote


Subject
Written By
Posted
Re: Need help on query which show total sum of result incorrect
November 29, 2017 12:16AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.