https://razorsql.com/features/firebird_features.html
https://infocotidiano.com.br/category/firebird
[code type=sql]
Update fabricante Set
codigo = 6
From fabricante f Join produto p
On f.codigo = p.cod_fabricante where f.codigo = 9 AND p.cod_fabricante = 9