title: Using select and values with insert into
body: <p>I'm writing a stored procedure.  I know how to pass values from <code>select</code> into <code>insert</code>.</p>
  
  <p>But, is it possible with <code>INSERT INTO</code> to use <code>values</code> and <code>Select</code> at the same time?</p>
  
  <pre><code>Insert into table_1 (f1, f2, f3, f4, f5, f6, f7, f8, f9,
        FL1, FL2, FL3)
  
        Select :p_f1, :v_f2, :p_f3, :p_f4,
          abs(:v_f5 * :p_f5),
          abs(:v_f6 * :p_f6),
          :v_f7, :v_f8, :v_9 from RDB$DATABASE
        UNION
        Select f_lookup_id from lookup_table where (f_res &gt;= :v_res) And (f2_lookup_id = :p_id1)
        UNION
        Select f_lookup_id from lookup_table where (f_res &gt;= :v_res) And (f2_lookup_id = :p_id2)
        UNION
        Select f_lookup_id from lookup_table where (f_res &gt;= :v_res) And (f2_lookup_id = :p_id3);
  </code></pre>