title: insert into table A, select from table A join B where condition from B, for each record that meets condition in B
body: <p>I want to insert into <code>table B</code> for a range of employees from <code>table A</code> where the <code>select</code> statement for the <code>insert</code> is from <code>table B</code>.
  To restate that; I have created all the records I need in <code>table B</code> for one employee (employeeid = 1).  Now I want to <code>insert</code> <code>into table B</code> similar records for a range of employees in <code>table A</code>.</p>
  
  <p>so far I have </p>
  
  <pre><code>insert TABLEB as B
  (EMPLOYEEID, COLUMN1, COLUMN2, COLUMN3)
       SELECT A.EMPLOYEEID, B.COLUMN1, B.COLUMN2, B.COLUMN3 
       FROM TABLEB 
       WHERE EMPLOYEEID = 1
  </code></pre>
  
  <p>now I want that to insert for each row in <code>Table A</code> that meets a selecion criteria</p>
  
  <p>the above works for one employee.  How do I make it iterate for a range of employees from <code>table A</code>.
  note that the EMPLOYEEID I want to insert for each row in <code>table B</code> will be the ID from the employee in <code>table A.</code></p>
  
  <p>Thanks,</p>