title: Advanced MySql Query: Update table with info from another table
body: <p>I would like to update a table in mySql with data from another table. </p>
  
  <p>I have two tables "people" and "business". The people table is linked to the business table by a column called "business_id". </p>
  
  <p>The necessary table structure, primary key is starred (Table: columns):
  People: *business_id, *sort_order, email
  Business: *business_id, email</p>
  
  <p>I would like to update the business table email column with the email from the people table, something like this (I know I am missing something here):</p>
  
  <pre><code>UPDATE business b SET email = (SELECT email  from People p where p.business_id = b.business_id AND sort_order = '1') WHERE b.email = ''; 
  </code></pre>
  
  <p>Does this make sense? Is it possible?</p>