A inventory list, a piece of outbound table,
I had a query, according to the commodity code, will the number of in-out warehouse stacking up,
But now I want to have a stock, this is the article number is how much remaining inventory, want to help me, please master
Will for the 2 tables to make two queries,
The inventory table together into this
The outbound table together into this
Requirements:
Now I want to do another query, will the two queries the same article number "combined" field to subtract (inbound and outbound),
Put different commodity number also together in this new query,