Is it possible to use more difficult updates by FB?

Something like:

update TABLE1 set id=TABLE2.id from TABLE2 where id in (1,2,3);

I mean useing selects in updates and inserts..


[Non-text portions of this message have been removed]