title: Getting duplicate rows on subquery
body: <p>So this has been bothering me for some time because I feel like in MSSQL this query would run just fine but at my new job I am forced to use Oracle. I have a subselect in a query where I want to find all of the people not assigned to a survey. My query is as follows:</p>
  
  <pre><code>Select distinct * From GetAllUsers, getperms
      Where id not in (getperms.users) and Survey_ID = '1'
  </code></pre>
  
  <p>If there are three users in the getperms table I get three rows for each person in the the GETALLUsers table.</p>
  
  <p>I guess I could do some kind of join and that's no problem, it's just really bothering me that this doesn't work when i think that it should.</p>