title: SQL and temporary row in SELECT query
body: <p>I'm using a custom combobox class which populates from a database with an SQL query as such:</p>
  
  <pre><code>playerCB-&gt;setDatabaseQuery("SELECT player.id, player.name FROM player WHERE player.team_id = " + QString::number(teamID) + " ORDER BY player.name;");
  </code></pre>
  
  <p>(internally this class keeps all selected values for each returned row).</p>
  
  <p>I would like to add a temporary row to the results where player.id = -1 and player.name = (Custom Player), however these should not exist within the database. It should be done with using SQL queries only as I can't make any changes to the combobox class. How would I go about doing this, would I have to use temporary tables or something?</p>