SQL Query Returning Deleted Rows
<p>I currently have the following table in my database, with the stated data in it:</p>

<p><strong>SUPPORT_USER_ROLES TABLE:</strong></p>

<pre><code>USER_ID  |   ROLE_ID
1        |   1
1        |   2
2        |   2
*2*      |   *1*
</code></pre>

<p>The bottom row, notated by '*' has been deleted and in SQL Developer there is no sign of it.</p>

<p>I am now running the following query:</p>

<pre><code>SELECT su.USER_ID
     , su.USERNAME
     , sur.ROLE_ID
     , sr.ROLE_NAME 
  FROM support_users su
     , support_users_roles sur
     , support_roles sr 
 WHERE su.USER_ID = sur.USER_ID 
   AND su.IS_ACTIVE != ‘N’ 
   AND sr.ROLE_ID = sur.ROLE_ID 
   AND sr.IS_ACTIVE != ‘N’
</code></pre>

<p>and it is returning the following:</p>

<pre><code>{  (USER_ID : 1, ROLE_ID : 1),  
   (USER_ID : 1, ROLE_ID : 2), 
   (USER_ID : 2, ROLE_ID : 1),  
   (USER_ID : 2, ROLE_ID : 2)  }
</code></pre>

<p>as you can see, it is still giving me:</p>

<pre><code>(USER_ID : 2, ROLE_ID : 1) 
</code></pre>

<p>even though it doesn't exist anywhere anymore.</p>

<p>I am using Java, JSF, PrimeFaces, SQL Developer, Hibernate, Weblogic and Eclipse IDE. I'm not sure if I'm massively missing something here and need to refresh/update something somewhere.</p>

<p>I haven't had this before so I'm massively confused at the moment :S</p>

<p>Any help is greatly appreciated!</p>