SQL: How to combines two results into one after case statement

  • Hi Experts,

    Can someone help me out?

    When I run the query , I am getting the duplicate of subtotal by Products. If there are two items with same ItemCode, I want to have combined Subtotal, instead of getting separately. As an instance, at line 3 and 4, there should be one subtotal at line 5 with total GrossWt. But I am getting two results for this. I would rather want one subtotal at line5 with result 1.008 GrossWt. How can I make it to achieve what I want? Please show me the way. Thanks

    Attached: image

  • Could you please read this article[/url] and follow instructions for posting? It's just really hard to help without consumable data. (Don't worry, it's all explained in the article...

  • It would be wise to wait for your answer on your original thread. Instead of opening a new thread. Where u haven't mentioned any details.

    Please refer to the following link Original Question Link for detail. thanks

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply