title: SQL Insert Table with Select
body: <p>How do i insert into a table using a select statement.
  The first_name, last_name, and id_no are from the staff table, but i want to insert the value 1 into the department table as well, but it is not from the staff table.</p>
  
  <pre><code>INSERT INTO department ('1',  id_no, first_name, last_name)
  SELECT FROM staff
  WHERE id_no = 1;
  </code></pre>
  
  <p>I am using SQL developer in oracle</p>