title: simple update with right join using mysql
body: <p>I have two tables that each include a identical value (in most cases)</p>
  
  <p>I am able to get the row ID from table 1, where table 1 value = table 2 value</p>
  
  <pre><code>SELECT wp_posts.ID
  FROM `wp_posts`
  RIGHT OUTER JOIN `wp_wpfb_files` ON wp_posts.post_name = wp_wpfb_files.file_display_name)
  </code></pre>
  
  <p>Now I want to update table 2 and set the column attach_id to equal the post ID from table 1 where they share the same value as per the results of the join. I'm having trouble wrapping my head around this.</p>
  
  <p>Thanks in advance for any help</p>