title: SQL WHERE statement after a JOIN with a WHERE clause
body: <p>I'm trying to select some data, I'm joining 3 tables together, but one of the joins has a where statement. Once I have done the joins I need to add another where statement to select a date range and a location. I am getting an error on the second WHERE clause.</p>
  
  <pre><code>  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' 
  </code></pre>
  
  <p>Would really appreciate any help.</p>
  
  <p>Thanks</p>