Hello,
I get an error message during executing the following statement: with mat as ( select a.teilenr, c.vkpreis, a.matteilenr, c.bezeichnung from tmaterial a left join tteile c on a.teilenr = c.teilenr where a.kundennr = 24823 ) update tteile set tteile.minvk = mat.vkpreis * 0.90 where teilenr = mat.teilenr I know, I can do the following (update XX where (select.) Why complain firebird the update..? Thank you, Best regards Olaf