Joining does not work properly

[dananjayaprasad]

Hello, 

I have 4 tables and I join them by product SKU, but when I try to create a table using Sale_AC and Inv to it does not work the way I want it. I want to see each place quantity, but it gives me total quantity for all location. I could not figure it out. Can anybody please tell me what’s wrong with it.

 

Thank you so much