title: Incorrect syntax near the keyword 'in'
body: <p>For the below query, I'm getting this error:</p>
  
  <blockquote>
    <p>Msg 156, Level 15, State 1, Line 3: Incorrect syntax near the keyword 'in'</p>
  </blockquote>
  
  <p>Query:</p>
  
  <pre><code>SELECT shedule.shedulId, shedule.shedudate, shedule.hometeam, shedule.awayteam
  FROM shedule
  where in
  (Select homeplay.shedulId from homeplay, shedule where shedule.shedulId != homeplay.shedulId);
  </code></pre>