ms access keep return an error once I use join statement

Question

I am trying to return a view using 2 joins statement on one query but somehow I keep getting this error

and my query as following:

SELECT First_Name, Second_Name, Last_Name, Course_Name, Date_Course, College_Name AS OperationDetails
FROM Operations
INNER Join Users
ON Operations.User_id = Users.User_Id
INNER Join Courses
On Operations.course_Id = Courses.Course_Id;

And this is my entire database relationship

Answer 1

MS Access has a strange requirement for parentheses for more than one JOIN:

SELECT First_Name, Second_Name, Last_Name, Course_Name, Date_Course, College_Name AS OperationDetails
FROM (Operations INNER JOIN
      Users
      ON Operations.User_id = Users.User_Id
     ) INNER JOIN
     Courses
     ON Operations.course_Id = Courses.Course_Id;