hi, you know how do i for update a table with the field of other table?

ej. in MS SQL SERVER i do it .

UPDATE tbl_equipos
SET tbl_equipos.radicada = tbl_radicadas.id_radicada
FROM tbl_equipos INNER JOIN tbl_radicadas ON tbl_equipos.esn =
tbl_radicadas.imei;

In firebir me works well

UPDATE tbl_equipos e
SET tbl_equipos.radicada = (SELECT id_radicada FROM tbl_radicadas r
WHERE e.esn = r.imei);

But the truth seems to me somewhat inefficient.

Does anyone know a better way to do this?

thanks ....