title: c# database sql inner join
body: <p>Hi I want to inner join my ActivityClub table with Clubs table so it can be updated into 2 tables. But so far my code didn't work. I'm using method class  and SQL Database.
  this is the error i get System.Data.SqlClient.SqlException: 'Incorrect syntax near the keyword 'INNER'.'</p>
  <pre><code> public int updateactivity(string clubname, string clubdesc, string activity, string achv)
      {
          int status = 0;
          string updateSQL = &quot;UPDATE ActivityClub SET club_desc=@desc, activity=@act, achievement=@acv INNER JOIN Clubs AS C1 ON C1.club_desc = Activity.club_desc WHERE club_name=@club&quot;;
          Connect();
          SqlCommand cmd = new SqlCommand(updateSQL, conn);
          
          cmd.Parameters.AddWithValue(&quot;@club&quot;, clubname);
          cmd.Parameters.AddWithValue(&quot;@desc&quot;, clubdesc);
          cmd.Parameters.AddWithValue(&quot;@act&quot;, activity);
          cmd.Parameters.AddWithValue(&quot;@acv&quot;, achv);
          status = cmd.ExecuteNonQuery();
          return status;
      }
  </code></pre>