title: Using insert into ... select results in a incorrect syntax near select, why?
body: <p>How can I make a SELECT inside an INSERT operation?</p>
  <pre><code>insert into tableX (a_id, b_id) 
  VALUES ((SELECT service_id 
           FROM tableY 
           WHERE id = 10, 2));
  </code></pre>
  <p>But the server returns a syntax error, why?</p>
  <pre><code>SQL Error [156] [S0001]: Incorrect syntax near the keyword 'select'.
  </code></pre>