Getting duplicate rows on subquery <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>