title: TableAdapter UpdateCommand on JOINed table
body: <p>Suppose I have a DataGridView that is loading from a TableAdapter whose content is from 2 JOINed tables, so Table C is:</p>
  
  <pre class="lang-sql prettyprint-override"><code>SELECT A.*, B.name LEFT JOIN B ON B.id = A.b_id
  </code></pre>
  
  <p>No UpdateCommand is generated for this by the wizard, I know. However, if the data of the table is almost entirely from Table A, and Table B is only joined in to provide the name of data referenced by id in Table A, can I just supply my own UpdateCommand that updates Table A if the user changes a value in the DataGridView?</p>
  
  <p>That is, I would like to set Table C's UpdateCommand to:</p>
  
  <pre class="lang-sql prettyprint-override"><code>UPDATE A SET value = [[new value]] WHERE id = [[current item]]
  </code></pre>
  
  <p>If worse comes to worse, I can make a dialog for the user to enter their new value into and do it that way. It just seems like it would be a lot simpler to do it as above. Will that method work?</p>