title: Which of these SQL queries is better and why?
body: <p>I'm still in the process of learning SQL. I've done similar queries in two different ways, and was wondering which is better and why.</p>
  
  <pre><code>UPDATE R
      SET R.something = 1
      FROM Table1 R
      JOIN Table2 U
      ON R.value1 = U.value2
      WHERE
          U.value3 BETWEEN 1 AND 5
  </code></pre>
  
  <p>or</p>
  
  <pre><code>UPDATE R
      SET R.something = 1
      WHERE R.value1 IN
      (SELECT U.value2
      FROM U
      WHERE
          U.value3 BETWEEN 1 AND 5
      )
  </code></pre>