MySQL Forums
Forum List  »  Newbie

Re: Need help on query which show total sum of result incorrect
Posted by: Peter Brawley
Date: November 29, 2017 10:53AM

If you wish us to read the query, post it here.

Again, please post the results of Show Create Table for cart_items, products and purchase_orders tables.

And please explain why price is not part of the problem.

> The expected result should be
> 1, 1, 1 for each product id.

We can do nothing with that information until you post Inserts for the dataset that generates the result you're having problems with.

Options: ReplyQuote


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


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.