Separate SqL query for Error 3258

Question

SELECT [Inventory Transactions Extended].Inventory.[Inventory ID], [Inventory Transactions Extended].Inventory.Item, Sum([Inventory Transactions Extended].[Actual Quantity]) AS [Current Stock], [Inventory Transactions Extended].[Reorder Level], [Target Stock Level]-[Current Stock] AS [Reorder Amount], [Inventory Transactions Extended].[Target Stock Level], [Inventory Transactions Extended].Category, [Inventory Transactions Extended].Location, [Supplier Query].Expr1

FROM (MaterialsOrder INNER JOIN ([Inventory Transactions Extended] LEFT JOIN [Supplier Query] ON [Inventory Transactions Extended].Supplier = [Supplier Query].[Supplier ID]) ON MaterialsOrder.[Supplier ID] = [Supplier Query].[Supplier ID]) INNER JOIN [MaterialsOrder Detail] ON MaterialsOrder.[Order ID] = [MaterialsOrder Detail].[Order ID]

GROUP BY [Inventory Transactions Extended].Inventory.[Inventory ID], [Inventory Transactions Extended].Inventory.Item, [Inventory Transactions Extended].[Reorder Level], [Inventory Transactions Extended].[Target Stock Level], [Inventory Transactions Extended].Category, [Inventory Transactions Extended].Location, [Supplier Query].Expr1;

What query should i separate and then rejoin ??

http://msdn.microsoft.com/en-us/library/office/jj729970(v=office.15).aspx

Answer 1

When you design this query you SHOULD see that the arrowed lines (indicating outer joins) point in the same direction, and all lines have arrows.

If that's not what you want, you can first create a query with the outer join:

([Inventory Transactions Extended] LEFT JOIN [Supplier Query]

then pull that query into your main query to replace these tables.