title: INNER JOIN condition not working
body: <p>Suppose we have table as :</p>
  
  <pre><code>EMPNO   ENAME   DEPTNO
  ------  ------  ----------
  7369    SMITH   20
  7499    ALLEN   30
  7654    MARTIN  30
  7788    SCOTT   20
  7839    KING    10
  7900    JAMES   30
  </code></pre>
  
  <p>How can we find all those employees who work in the same deptno as of SCOTT ?
  I tried as follows :</p>
  
  <pre><code>SELECT e.ename FROM employee e INNER JOIN employee m ON e.deptno=m.deptno;
  </code></pre>
  
  <p>, but the result isn't correct.</p>