syntax error - sql

Question

I am trying to write a query in SQL but I get a syntax error in access. i have check various code checkers online but they all say there are no issues. Can anyone help?

   SELECT
      PROJECT.ProjectID,
      PROJECT.Name,
      PROJECT.Department,
      EMPLOYEE.EmployeeNumber,
      EMPLOYEE.LastName,
      EMPLOYEE.FirstName,
      EMPLOYEE.Phone 
   FROM
     ASSIGNMENT 
     INNER JOIN
         EMPLOYEE 
         ON ASSIGNMENT.EmployeeNumber = EMPLOYEE.EmployeeNumber 
     INNER JOIN
         PROJECT 
         ON ASSIGNMENT.ProjectID = PROJECT.ProjectID;

score 1 · Accepted Answer · answered Sep 20 '17 at 20:24

1

MS Access requires parentheses for multiple JOINs:

FROM (ASSIGNMENT INNER JOIN
      EMPLOYEE 
      ON ASSIGNMENT.EmployeeNumber = EMPLOYEE.EmployeeNumber 
     ) INNER JOIN
      PROJECT 
      ON ASSIGNMENT.ProjectID = PROJECT.ProjectID;

answered Sep 20 '17 at 20:24

Gordon Linoff

1,242,037
58
646
786

OMG Thank you so much. I knew it had to be something simple. – Scholarmate Sep 20 '17 at 20:27

syntax error - sql

1 Answers1