title: UpdateCommand for Asp GridView using a join between two tables
body: <p>I have two tables that I join <strong>sims</strong> and <strong>transactionlog</strong> and display in a Asp GridView using a SQLDatasource</p>
  
  <p>Then I have an ASP GridView with the following select and update statements:</p>
  
  <pre><code>SelectCommand="SELECT * FROM sims s INNER JOIN TransactionLog AS tl ON s.id = tl.SimsId"     
  UpdateCommand="UPDATE SET s.Notes=@Notes FROM sims s INNER JOIN TransactionLog AS tl ON s.id = tl.SimsId WHERE s.id=@id and tl.Id=@Id1"
  </code></pre>
  
  <p>Right now I only have the Notes column not set to readonly, but would like to add the others in later as soon as I can get the update statement to work for the notes column first.</p>
  
  <p>When I try to update the notes column the error I'm getting is the following:
  <strong>Incorrect syntax near the keyword 'SET'.]</strong></p>
  
  <p>Mmm, hope my question is stated clearly enough.</p>