title: MYSQL update a table based on another table's data
body: <p>I have 2 MySQL tables like these</p>
  <ol>
  <li>Table main</li>
  </ol>
  <p>| email | bounce | status |</p>
  <ol start="2">
  <li>Table bounce</li>
  </ol>
  <p>|email |</p>
  <p>what i want is a query to update the (bounce and status column) main table with respect to the data from bounce table</p>
  <p>this is the query i tried, <code>update main inner join bounce on (main.email = bounce.email) set main.bounce='yes' and main.status='Inactive';</code></p>