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!