title: Based on the following MYSQL query how can I write an UPDATE statement to update a value?
body: <p>I'm using the following SQL query to get the records I need from a Wordpress database.</p>
  
  <pre><code>SELECT p.id, p.post_title, m.meta_key, m.meta_value, t.slug
  FROM wp_posts p
  INNER JOIN wp_postmeta m ON p.id=m.post_id 
  AND m.meta_key='_subscription_sign_up_fee'
  INNER JOIN wp_term_relationships AS tr ON p.id = tr.object_id
  INNER JOIN wp_term_taxonomy AS tt ON tr.term_taxonomy_id = tt.term_taxonomy_id
  INNER JOIN wp_terms AS t ON tt.term_id = t.term_id    
  WHERE t.slug = 'bundle'
  </code></pre>
  
  <p>This pulls the correct records. My issue is that I need to increase the value of the _subscription_sign_up_fee by 100.</p>
  
  <p>I've tried the following</p>
  
  <pre><code>update wp_postmeta
  set wp_postmeta.meta_value = wp_postmeta.meta_value + 100 
  INNER JOIN wp_postmeta m ON wp_posts.id=m.post_id 
  AND m.meta_key='_subscription_sign_up_fee'
  INNER JOIN wp_term_relationships AS tr ON wp_posts.id = tr.object_id
  INNER JOIN wp_term_taxonomy AS tt ON tr.term_taxonomy_id = tt.term_taxonomy_id
  INNER JOIN wp_terms AS t ON tt.term_id = t.term_id   
  WHERE t.slug = 'bundle'
  </code></pre>
  
  <p>and get an error saying that 'Column 'meta_value' in field list is ambiguous '
  I'm pretty sure I'm not understanding the aliases. Can someone point me in the right direction?</p>