title: How do I UPDATE from a SELECT in Informix?
body: <p>I'm trying to do an update using data from another table. I've tried <a href="https://stackoverflow.com/a/18612728/1476885">this answer</a> (the second part), but it is not working for me. I'm receiving a generic error message of syntax error.</p>
  
  <p>I've also tried <a href="https://stackoverflow.com/a/12493901/1476885">this solution</a> and received a syntax error message too.</p>
  
  <p>If I try to update just one column, it works:</p>
  
  <pre><code>UPDATE dogs
  SET name = 
      (
          SELECT 'Buddy'
          FROM systables 
          WHERE tabid = 1
       );
  </code></pre>
  
  <p>But I need to update multiples columns. Unfortunately, this is not working:</p>
  
  <pre><code>UPDATE dogs
  SET (name, breed) = 
      (
          SELECT 'Buddy', 'pug'
          FROM systables 
          WHERE tabid = 1
      );
  </code></pre>
  
  <p><sup>Informix version is 12.10.FC8</sup></p>