SQL Query Request - SKUs with stock levels for every available location

Does anybody have a query to show SKUs with Stock levels for every available location?

Apparently, there is no way to simply compare what stock levels for SKUs you have across locations??

Ideally, the table should be something like this:

SKU / Item Title / Stock Level at Location "x" / Stock Level at Location "xx" /...

Tried to do it but struggling to figure out how to join the stock level for each location.



Login to post a comment