带有WHERE子句的JOIN之后的SQLWHERE语句

我正在尝试选择一些数据,我将3个表连接在一起,但其中一个连接有一个where语句.完成连接后,我需要添加另一个where语句来选择日期范围和位置.我在第二个WHERE子句上收到错误.

  SELECT a.[ID]
      ,a.[item_no]
      ,a.[qty]
  FROM [MYDB].[dbo].[details] AS a


  INNER JOIN [MYDB].[dbo].[delivery] AS b
  ON a.[item_no] = b.[item_no]
  INNER JOIN [MYDB].[dbo].[options] AS c
  ON a.[number] = c.[number] 
  WHERE a.[item_no] = c.[item_no]

WHERE b.[destination] = 'my destination'
AND b.[date] BETWEEN '2018-10-14' AND '2018-10-15' 

非常感谢任何帮助.

谢谢

试试以下

SELECT a.[ID]
      ,a.[item_no]
      ,a.[qty]
  FROM [MYDB].[dbo].[details] AS a


  INNER JOIN [MYDB].[dbo].[delivery] AS b
  ON a.[item_no] = b.[item_no]
  INNER JOIN [MYDB].[dbo].[options] AS c
  ON a.[number] = c.[number] 
  and a.[item_no] = c.[item_no]

WHERE b.[destination] = 'my destination'
AND b.[date] BETWEEN '2018-10-14' AND '2018-10-15'