title: MSSql Query Issue
body: <p>I have three tables</p>
  
  <pre><code>-Projects(ProjectId[PK], Status ...)
  -UserProjects(UserProectId[PK], ProectId[FK], UserId[FK], ...)
  -Users(UserId[PK], ...)
  </code></pre>
  
  <p>I want choose projects with status = 1 and project must be project which user is not involved.</p>
  
  <p>Here is what I`ve tried:</p>
  
  <pre><code>Select UP.ProjectId from UserProjects UP
  Join Projects P on UP.ProjectId = P.ProjectId
  Where P.Status = 1 AND UP.UserId != 1
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/ZvFB9.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ZvFB9.png" alt=""></a></p>
  
  <p>Result which I want should be just 16. It gives me also 17 because User 1 and User 3 are in Project 17.</p>
  
  <p>Anyone know how to solve this problem ?</p>