SQL syntax error missing operator help

[virgilio]

Can I get some help sorting out a SQL error?

This is my query:

      FiltStr = "'[LOT_STATUS] = 'In Test'"

      strSQL = "SELECT LOT_DATES.LOT_NUMBER, LOT_DATES.LOT_STATUS, LOT_DATES.SPEC_NUM, " _
      & "SPEC_DATA.SPEC_DESC, SPEC_DATA.SPEC_NOTES, SPEC_DATA.SAP_NUM, LOT_DATES.TST_COM_SELECTED, " _
      & "LOT_DATES.TST_QCA_SELECTED, LOT_DATES.TST_BET_SELECTED, LOT_DATES.TST_BB_SELECTED, " _
      & "IIf([RM_REJECT_TRUE]=False And [LOT_STATUS]<>'DISPOSITIONED','OPEN','CLOSED') " _
      & "AS OPEN_STATUS " _
      & "FROM LOT_DATES WHERE " & FiltStr & " " _
      & "INNER JOIN SPEC_DATA ON LOT_DATES.SPEC_NUM = SPEC_DATA.SPEC_NUM " _
      & "ORDER BY LOT_DATES.RECORD_ID;"

My error is

Run-Time error '3075':
Syntax error (missing operator) in query expression '[LOT_STATUS] = 'In Test' INNER JOIN  SPEC_DATA ON LOT_DATES.SPEC_NUM = SPEC_DATA.SPEC_NUM'.

[orange]

Your where clause is in the wrong location.

Inner Join
then where

then Order By