title: most efficient way to UPDATE a table using critera from other tables?
body: <p>What is the most efficient/fastest way to update a table that requires foreign keys (to other tables) in the criteria?</p>
  
  <p>I normally do it this way:  </p>
  
  <pre><code>UPDATE table1 WHERE table1_id in (SELECT table1_id FROM table2 WHERE whatever)
  </code></pre>
  
  <p>But I'm trying to figure out if there is a more efficient way that avoids the subquery.  </p>
  
  <p>The reason I want to know is because I JUST yesterday learned that it's possible to delete without a subquery like this:</p>
  
  <pre><code>DELETE t1 FROM table1 t1
  JOIN table2 t2 ON t1.table1_id = t2.table1_id 
  WHERE whatever
  </code></pre>
  
  <p>But I can't figure out how to apply the same JOIN technique to an UPDATE statement</p>