How do I subquery the right results
<p>I am trying to do a join subquery to return just employee names that earn less than 46000 and I can get it to work by also returning the employee id but not without it.</p>

<p>This is how Im doing it.</p>

<pre><code>Select e.eid, e.ename
From employee_table e
Inner Join (
Select salary, eid 
from salary
Where salary &gt; 46000
) as s
On e.eid = s.eid;
</code></pre>