Hi, I am trying to build a excel report using SQL to give me MRP demand. I have built 90% of the report but need to add in the works orders required/demand quantities which haven't been allocated to stock. Below is my current query - any help would be appreciated?

SELECT
StockItem.Code,
StockItem.Name,
ProductGroup.Code,
StockItem.FreeStockQuantity,
StockItem.ItemID,
NLCostCentre.Name,
NLCostCentre.Code,
StockItem.AverageBuyingPrice,
StockItem.StandardCost,
WarehouseItem.ReorderLevel,
WarehouseItem.MinimumLevel,
WarehouseItem.MaximumLevel,
WarehouseItem.ConfirmedQtyInStock,
WarehouseItem.UnconfirmedQtyInStock,
WarehouseItem.QuantityAllocatedSOP,
WarehouseItem.QuantityAllocatedStock,
WarehouseItem.QuantityOnPOPOrder,
WarehouseItem.QuantityAllocatedBOM
FROM
XXX.dbo.NLCostCentre NLCostCentre
INNER JOIN XXX.dbo.NLNominalAccount NLNominalAccount
ON NLCostCentre.NLCostCentreID = NLNominalAccount.NLCostCentreID
INNER JOIN XXX.dbo.StockItemNominalCode StockItemNominalCode
ON NLNominalAccount.NLNominalAccountID = StockItemNominalCode.NominalCodeID
INNER JOIN XXX.dbo.StockItem StockItem
ON StockItemNominalCode.ItemID = StockItem.ItemID
INNER JOIN XXX.dbo.ProductGroup ProductGroup
ON ProductGroup.ProductGroupID = StockItem.ProductGroupID
LEFT JOIN XXX.dbo.WarehouseItem WarehouseItem
ON WarehouseItem.ItemID = StockItem.ItemID
WHERE
NLNominalAccount.AccountNumber = '4000'
ORDER BY
StockItem.Code;

Thanks,

Jo