title: select from table and update another table SQL
body: <p>i'm trying to get 'business_id' and 'rating' from the table 'reviews' where 'review_id' is $approveReviewID </p>
  
  <p>and then update 'rating' in 'business_details' with this retrieved rating from 'reviews' where 'business_id' is equal to that retrieved.</p>
  
  <p>i have these two queries,</p>
  
  <pre><code>SELECT business_id, rating FROM reviews WHERE review_id = '$approveReviewID';
  
  UPDATE business_details SET rating = rating + $rating WHERE business_id = '$businessID';
  </code></pre>
  
  <p>is there a way to join these queries into one?</p>