Hello,

b> Exist a more efficient way of doing an update multi tables?

what I would use is an UPDATE statement inside a FOR SELECT loop, all
packed into an EXECUTE BLOCK call. See the docs for details.

HTH
--
Nando Dessena
======================================================
I support Firebird, I am a Firebird Foundation member!
Join today at http://www.firebirdsql.org/ff/foundation
======================================================