title: Select multiple column in one table
body: <p>I am new to sql.
  I want to view <code>id + ' ' + name</code> in ComboBox as <code>displaymember</code> and also <code>id</code> as <code>valuemember</code>, so sql would look like:</p>
  
  <pre><code>SELECT id, id + ' ' + name from tblproduct;
  </code></pre>
  
  <p>However, it doesn't work! i'm really appreciate for every one who can help me!</p>