-
SQL Query in Access
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!
-
Re: SQL Query in Access
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. ;)
-
Re: SQL Query in Access
LEFT JOIN TABLENAME ON (condition) is the syntax
not...
LEFT JOIN (condition)
-
Re: SQL Query in Access
Can you rewrite that SQL statement to fit what you are saying...i'm not sure if I fully get the concept...