title: ADODataSet deleting from joined table
body: <p>I have a Delphi app where I display a list of games that have been played from a query like this:</p>
  
  <pre><code>select  g.*, gt.id, gt.descr 
  from GAMES g 
  inner join game_types gt on gt.id = g.game_type
  order by game_date DESC
  </code></pre>
  
  <p>When I click the delete button in the DBNavigator, the joined record from the game_types table is also deleted.  That's a problem because many other games can be of the same type.</p>
  
  <p>What do I need to do to make it so that only the game is deleted but not the game type?</p>