title: Subquery cannot appear in an Insert Values statement
body: <p>I have the following query in SQL Server CE which gives me an error during the execution time:</p>
  
  <pre><code>INSERT INTO trans_rel(trans, sale_purch_id, inc_exp_id)
   VALUES('p', 104, (select MAX(expence_id) from c_expence))
  </code></pre>
  
  <p>The error is this:</p>
  
  <blockquote>
    <p>Subquery cannot appear in an Insert Values statement.</p>
  </blockquote>
  
  <p>What is wrong with this query?</p>