Hello guys,
This forum has been a life saver for me.
I have a question within query, let us say I have 2 customers, customer 1 and 2. Customer 1 bought 5 books of X and customer 2 bought 6 books of X now in my orders tables I have custId 1 and 2 and when I run query it shows product X twice one for cust 1 and second for cust 2. so it shows 5 and 6 quantity, how can I get the total of these?
Thank you