title: Msg 156, Level 15, State 1, Procedure inventory, Line 6 [Batch Start Line 2] Incorrect syntax near the keyword 'Where'
body: <p>How can I fix this error:</p>
  
  <blockquote>
    <p>Msg 156, Level 15, State 1, Procedure inventory, Line 6 [Batch Start Line 2]<br>
    Incorrect syntax near the keyword 'Where'</p>
  </blockquote>
  
  <p>This is my code </p>
  
  <pre><code>create view inventory ([name], [description], [price])
  as 
      Select
          name, description, MaxPrice
      From
          item
      Join 
          ITEM_TYPE 
      Where
          item_id not in (Select itemid
                          From ORDER_ITEM
                          Where itemid not in (Select ItemID
                                               From ITEM_DONATION
                                               Where itemid not in (Select itemid
                                                                    From item pickup)))
  Go 
  </code></pre>