something wrong with this join

[qwertyjjj]

Access doesn't like the inner join here. Any ideas why?

SELECT Structure.[Div Level Description],
((SUM([1To90]) + SUM([Not Due]) + SUM([91To120])) / 1000) AS [Months0To3],
((SUM([121To150]) + SUM([151To180])) / 1000) AS [Months4To5],
(SUM([181To365]) / 1000) AS [Months6To12],
(SUM([MoreThan366]) / 1000) AS [Months12+],
((SUM([1To90]) + SUM([Not Due]) + SUM([91To120])) + (SUM([121To150]) + SUM([151To180])) + SUM([181To365]) + SUM([MoreThan366])) / 1000 AS TotalDebt
FROM (zarageddebt_CURR
LEFT JOIN Structure ON Structure.[Cost Centre]=zarageddebt_CURR.[Profit ctr])
INNER JOIN baddebt_CURR ON Structure.[Cost Centre]=baddebt_CURR.[Profit ctr]
GROUP BY Structure.[Div Level Description];

 

[PHV]

I wonder why an outer join on Structure ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[qwertyjjj]

There are some NULL fields in zarageddebt_CURR, so I want it to pick up those fields but get other information from Structure.

With SQL Server, you just put all the joins in without brackets, so this is confusing me somewhat as it changes the structure of the joins somehow ?