title: How to do a JOIN in Oracle SQL?
body: <p>I have two tables <code>Users</code> and <code>User_Org</code>.</p>
  
  <ul>
  <li>Users ( user_id,first name,last name, active_ind, email)</li>
  <li>User_Org (user_id, org_id)</li>
  </ul>
  
  <p>I have to write a Oracle SQL query, where it should return all users whose active_ind is 1 and org_id of associated user in User_org match the given org_id.</p>
  
  <p>I have tried below, it is not working</p>
  
  <pre><code>select *
  from Users u
    join User_ORG  org        
  where org.ORGANIZATION_ID = 12345 
    and Active_ind != 0;
  </code></pre>