|Subject||RE: [firebird-support] Multiple table update question|
> As far as I can recall the syntax is like thisHi Norman,
> update T1
> SET T1.field2 = T2.field2
> FROM table1 T1
> INNER JOIN table2 T2 on (T1.field1 = T2.field2);
> although I am open to correction. I have not used it for a
> while, and the syntax is somewhat arcane.
> If this does not work, let me know and I'll look it up in one
> of my SQL resources.
I tried your suggestion, but unfortunetly I get the following error:
ISC ERROR MESSAGE:
Dynamic SQL Error
SQL error code = -104
Token unknown - line 3, char 1