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?
My SQL skills are a bit rusty so any help appreciated.
thanks for your time.
I get an error saying Syntax mistake by the keyword FROM.
If i remove the 2nd Right Join the query runs?
Code:
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.