> As far as I can recall the syntax is like this
>
> 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.
>

Hi Norman,

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
FROM

Thank you

daniel