Hi, I was wondering if the post I made sort of were clear. I have been working on the query myself trying to get to that quantity but still no luck.
I tried using a left join to get to the quantity ordered in version 1 but that does not work for some orders like S19856 that contain and Item that was added on version 3.
I understand if you do not have time to help right now, just thought I made sure I was not missing anything.
Thank you kindly.