Hi Folks,
I am working on a query that provides me quantities in two warehouses.
and it pulls out the info like this.

what I am trying to achieve here is, if I input WHCODE of my choice it shows the data of only that WH instead of both.
it is to avoid the duplication of data in both WHs. for example, if i have quantity in both WHs, the above query will show me data of (2+3) = 5 times and I don't know that which serial # belongs to which WH.
Any help that leads me to solve this would be appreciated.