Error 3258 ambiguos outer joins

[brainst0rm]

Hi there. I have this query:

SELECT [Range Plan 2006].[Parent Category] AS Expr1, 
[Range Plan 2006].Attribute AS [Sub category],
[This Year All Prog].Category, 
[This Year All Prog].Product, 
[Description Master].Description, 
[This Year All Prog].SumOfQty AS [TY Cum Qty],
 [This Year All Prog].SumOfValue AS [TY Cum Value], 
[This Year All Prog].AvgOfMargin AS [TY Cum Margin],
[Last Year All Prog].SumOfQty AS [LY Cum Qty], 
[Last Year All Prog].SumOfValue AS [LY Cum Value], 
[Last Year All Prog].AvgOfMargin AS [LY Cum Margin], 
[Last Year All Wk].SumOfQty AS [LY Wk Qty], 
[Last Year All Wk].SumOfValue AS [LY Wk Value], 
[Last Year All Wk].AvgOfMargin AS [LY Wk Margin], 
[This Year All Wk].SumOfQty AS [TY Wk Qty], 
[This Year All Wk].SumOfValue AS [TY Wk Value], 
[This Year All Wk].AvgOfMargin AS [TY Wk Margin], 
[Weekly Product Sales Analysis Stock].Qty AS [Total Stock], 
[Weekly Product Sales Analysis Stock].[Outstanding PO's], 
[Weekly Product Sales Analysis Stock].[Total Commitment] AS [Total Commit], 
IIf(IsNull([Product List - New].product),"",IIf(Year([Product List - New].[date entered])<Forms![Menu - Weekly Reports]!Year,"","NEW")) AS NEW, 
[Range Plan 2006].[Product Code] AS Expr2

FROM [Range Plan 2006], ((((([This Year All Prog] 
LEFT JOIN [Last Year All Prog] ON [This Year All Prog].Product = [Last Year All Prog].Product) 
LEFT JOIN [Last Year All Wk] ON [This Year All Prog].Product = [Last Year All Wk].Product) 
LEFT JOIN [This Year All Wk] ON [This Year All Prog].Product = [This Year All Wk].Product) 
LEFT JOIN [Weekly Product Sales Analysis Stock] ON [This Year All Prog].Product = [Weekly Product Sales Analysis Stock].Product) 
LEFT JOIN [Description Master] ON [This Year All Prog].Product = [Description Master].Product) 
LEFT JOIN [Product List - New] ON [Description Master].Product = [Product List - New].Product;

when I start it, access tells me that there are some ambiguous outer joins. I don't understand so much about outer joins, could you help me plz?

Thanks.

 

[Dennisk]

it means that you have a incompatible mix of joins. Right Click each join starting from the left. If your first join is 'Show all records from xxxxxx (leftmost table) and only those from xxxxx where the join is equal' then set all your joins to that type or just experiment with join types

 

[brainst0rm]

I'm sorry, but I didn't understand where I have to click...

 

[Dennisk]

in the QBE window, it will be divided into two. the top half consists of the tables/queries with lines joining them. Carefully right click on the relationship line and a context menu should appear showing:-

Join Properties
Delete

select the join properties and a dialog box will appear allowing you to specify the type of join.

 

[brainst0rm]

Thanks, I resolved