SQL query in Ms access

Question

Can anyone tell me what is wrong with this query, it says syntax error.But syntax looks good for me.

SELECT Errortypereport.[Job Design Control],
       Errortypereport.[Detailer Name], Errortypereport.SuppilerName,
       Errortypereport.[Part Number], Errortypereport.[Change Level],
       Errortypereport.[Event Type Selected], Errortypereport.[Tracking Number],
       Errortypereport.[Event Date], Errortypereport.[Error Type Selected],
       Errortypereport.[Sub Type Selected], Errortypereport.ErrorSubTypeComment,
       Errortypereport.[Fundamental Errors Qty],
       Errortypereport.[Information Errors Qty],
       Errortypereport.[Readability Errors Qty], Errortypereport.[Error Sub Type Ref],
       Errortypereport.Enteredby, Errortypereport.[Wrapper engineer]
FROM Errortypereport INNER JOIN
     POSBLD ON (Errortypereport.Part Number)=(POSBLD.PartNumber)
           And (Errortypereport.Change Level)=( POSBLD.ChangeLevel);

error message is: syntax error (missing operator) in query expression '(Errortypereport.Part Number)=(POSBLD.PartNumber) And (Errortypereport.Change Level)=( POSBLD.ChangeLevel)'

Answer 1

If you have spaces in column names you need to wrap them around [ ]'s.

There is a space between Part and Number in your On as well as change level

ON (Errortypereport.Part Number)=(POSBLD.PartNumber) And (Errortypereport.Change Level)=( POSBLD.ChangeLevel);

Change it to:

ON (Errortypereport.[Part Number])=(POSBLD.PartNumber) And (Errortypereport.[Change Level])=( POSBLD.ChangeLevel);

Answer 2

try

ON Errortypereport.[Part Number]

and

Errortypereport.[Change Level]