Oracle: select from two tables
<p>I have two tables <code>EMPLOYEE</code> and <code>DEPARTMENT</code>.</p>

<p>Columns of the <code>DEPARTMENT</code> table:</p>

<pre><code> DEPARTMENT_ID
 DEPARTMENT_NAME
 MANAGER_ID
 LOCATION_ID
</code></pre>

<p>Columns of <code>EMPLOYEE</code> table</p>

<pre><code>EMPLOYEE_ID
FIRST_NAME
LAST_NAME
EMAIL
PHONE_NUMBER
HIRE_DATE DATE
JOB_ID
SALARY
COMMISSION_PCT
MANAGER_ID
DEPARTMENT_ID
</code></pre>

<p>When the desired number appears <code>DEPARTMENT_ID</code> chose <code>EMPLOYEE_ID</code></p>

<pre><code>FIRST_NAME
LAST_NAME
EMAIL
PHONE_NUMBER
HIRE_DATE DATE
JOB_ID
SALARY
COMMISSION_PCT
MANAGER_ID
DEPARTMENT_ID
</code></pre>