Are ordinary sql queries different from MS Access 2007 queries?
I have this simple query but it is not working in MS Access query (SQL View). What is wrong with this?
SELECT StudentSubject.*, Subject.*,Professor.*, Student.*, Church.*
FROM
(
SELECT StudentSubject.*, Subject.*,Professor.* , Student.*
FROM
(
SELECT StudentSubject.*, Subject.*,Professor.*
FROM
StudentSubject
LEFT JOIN Subject ON StudentSubject.SubjectID=Subject.SubjectID
INNER JOIN Professor ON Subject.ProfessorID=Professor.ProfessorID
)
INNER JOIN Student ON StudentSubject.StudentID=Student.StudentID
)
LEFT JOIN Church ON Student.ChurchID=Church.ChurchID;
I believe this would work if I was using MySQL/MSSQL(If I use alias and do it directly - this is the ouput of ms access sql designer)
I get syntax error on join operation. But MS Access doesn't point out which join.