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.

Quoting Daniel Jimenez <d.jimenez@...>:

>
>
>
>
>
> > This being the case, I'd use a join update.
>
> >
>
>
>
>
>
> So from what you mention, can I take this as FB does not allow the
>
> following?
>
>
>
> UPDATE table1, table2
>
> SET table1.field2 = table2.field2
>
> WHERE table1.field1 = table2.field2;
>
>
>
> Could you provide a simple sample of the JOIN UPDATE please
>
>
>
>
>
> daniel
>
>
>
>
>
>
>
>
>
>
>
>
>
> Yahoo! Groups Links
>
>
> To visit your group on the web, go to:
> http://groups.yahoo.com/group/firebird-support/
>  
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>  
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
>
>
>
>
>
>
>
>
>
>
>
>

"See how deep the rabbit hole goes...."