title: How to use inner join in oracle 11g?
body: <p>I am running my Oracle query here but it's not working but the same query is working in SQL Server</p>
  
  <p>Here is my query:</p>
  
  <pre><code>SELECT d.dept_code,
         d.dept_name,
         d.dept_desc,
         e.comp_name
  FROM   dept_master d
         inner join comp_master e
                 ON d.comp_id = e.comp_id 
  </code></pre>
  
  <p>where in <code>dept_master.comp_id</code> value is the same as in <code>Dept_Master</code> table.</p>