I need a report, a side by side inventory count if you will…
I tried a few statements but just can not get it.
But it would be something like this:
SELECT
inventory.sku
, inventory.description_short
FROM
inventory
JOIN inventory_history
ON inventory.sku = inventory_history.sku
(
SELECT SUM(remaining)
FROM inventory_history
WHERE
inventory_history.store_id = 5
) AS qty_cortes,
(
SELECT SUM(remaining)
FROM inventory_history
WHERE
inventory_history.store_id = 4
) AS qty_rio,
(
SELECT SUM(remaining)
FROM inventory_history
WHERE
inventory_history.store_id = 5
) AS qty_brickbay,
GROUP BY
inventory.sku
Please let me know how I could do this, Thanks, AM