Hello,

I'm trying to write an stored procedure that should update the records of
the main database, with the contents of a temporal database. The query
should be written as:

UPDATE states set state_name = tmpStates.state_name FROM states INNER JOIN
tmpStates ON state.state_code = tmpStates.state_code;

It doesn't work at all.
I really can figure out several ways to write the sql to achieve the results
desired, but I'd like to know the optimal solution for this query in
FireBird.

TVMIA,
Klerman