title: update sql query using joins informix
body: <p>I have one table table1 (id, name, surname, ssn) and a view1 (id, ssn) and here is my update clause</p>
  
  <pre><code>update table1 set 
  ssn=v.ssn
  from table1 t,view v 
  where t.id=v.id
  </code></pre>
  
  <p>However I get syntax error  sql code -201, does anybody knows what is the problem?</p>