SQL Query in Access

[Cran56]

I have this sql query:

SELECT Sum(Fees_Paid.Student_Fee_Paid) AS SumOfStudent_Fee_Paid
FROM Fees_Paid LEFT JOIN (Camp_Session_And_Date INNER JOIN Camp_Registration ON Camp_Session_And_Date.Camp_Session_ID = Camp_Registration.Camp_Session_ID) ON Fees_Paid.Payment_ID = Camp_Registration.Payment_ID
WHERE (((Camp_Session_And_Date.Camp_Year)=[Year]))
GROUP BY Camp_Session_And_Date.Camp_Year;

It is telling me that I have ambigious joins and that I need to break it up into 2 select statements within the same query...I tried breaking it up but can't seem to get around all of the errors when I do. How can I break this up to where it will give me a errorless response.

HELP!

[RobDog888]

Even though this is in Access VBA it would get a better response in the Database Forum.
Probably just post a link to this thread so the responses will all be in one thread.

[szlamany]

LEFT JOIN TABLENAME ON (condition) is the syntax

not...

LEFT JOIN (condition)

[Cran56]

Can you rewrite that SQL statement to fit what you are saying...i'm not sure if I fully get the concept...