title: How can I use a select in update?
body: <p>I have a Firebird server and I need to execute an update on a table on this server.</p>
  
  <p>I should update those rows which the inner select gives back.</p>
  
  <p>I have this SQL, and it runs on error at <code>from(</code></p>
  
  <pre><code>update szamla_tortenet as s1
  set s1.elso_atadas=1
  FROM(
  SELECT CEGKOD,KBIZ_ID,MIN(INS_dATE)
  from SZAMLA_TORTENET AS S2
  GROUP BY CEGKOD,KBIZ_ID
    )  as sq
    where s1.ins_date=sq.ins_date
  </code></pre>