title: Target table not Updatable error
body: <p>I need to run this query :</p>
  
  <pre><code>UPDATE (
     SELECT r.* 
     FROM booked r 
     INNER JOIN (
        SELECT a.st_code as from_t
             , b.st_code as to_t 
        FROM `stops_at` a 
        CROSS JOIN `stops_at` b 
        WHERE (a.stop_no &lt; b.stop_no) 
          and (a.train_no = b.train_no) 
          and (a.train_no = '11280')
        ) new 
     ON (r.st_from = new.from_t) 
       and (r.st_to = new.to_t)
       and r.date = '2013-04-16'
     ) temp 
  SET temp.seat_ac = temp.seat_ac-5
  </code></pre>
  
  <p>but on execution it gives an error:</p>
  
  <p><strong>#1288-The target table temp of the UPDATE is not updatable</strong>.</p>
  
  <p>Any solutions?</p>