title: update and select in one SQL query
body: <p>I wrote a query that updates a field in a table but I wish to add an additional parameter - the name of the student (that inside a different table - &quot;Students&quot;)</p>
  <p>This is what I wrote till now (just an example):</p>
  <pre><code>UPDATE Grades
  SET FinalExam = 90
  FROM Grades AS grd
  INNER JOIN Students
  ON grd.Exam_ID = Students.Exam_ID
  WHERE grd.BOUNUS = 1
  </code></pre>
  <p>How can I add a select method in this query to return me the Students name?</p>