query MS Access using SQL 1

[AGus01]

Hi can anyone advise why I get an error running this query:
I get an error saying Syntax mistake by the keyword FROM.
If i remove the 2nd Right Join the query runs?

select 
cou.name,
cou.details,
cou.startdate,
cou.venue
from tblCourses as cou
Right Join tblCourseAttendees as ca ON  cou.courseid = ca.courseid 
Right Join tblContacts as con ON ca.contactid = con.Contactid
 Where cou.courseid=2

My SQL skills are a bit rusty so any help appreciated.
thanks for your time.

 

[Remou]

You appear to be missing some brackets.

select 
cou.name,
cou.details,
cou.startdate,
cou.venue
from (tblCourses as cou
Right Join tblCourseAttendees as ca ON  cou.courseid = ca.courseid)  
Right Join tblContacts as con ON ca.contactid = con.Contactid
 Where cou.courseid=2

 

[AGus01]

Hi Ramou,

thanks for getting back to me. That was a great help. So you need to use parenthesis in MS Access.

can you confirm to me if I was to add a third table to the query i would the syntax as follows:

select
cou.name,
cou.details,
cou.startdate,
cou.venue
from ((tblCourses as cou
Right Join tblCourseAttendees as ca ON  cou.courseid = ca.courseid)  
Right Join tblContacts as con ON ca.contactid = con.Contactid)
Right Join tblName as t ON  t.tableid = con.tableid 
 Where cou.courseid=2

 

[Remou]

That looks right to me.