title: Sybase insert statement with subqueries of select
body: <p>I am trying to do an <code>insert</code> with subqueries but this <code>insert</code> fails:</p>
  
  <pre><code>insert into 
      TABLE_A(COL_A, COL_B, COL_C, COL_D, COL_E, COL_F)
      values (
          1, 
          (select COL_B from TABLE_B where user_name = 'foo'),
          (select COL_C from TABLE_C where age = 25),
          2,3,4);
  </code></pre>
  
  <p>I tried to write it different but it still fails.</p>