Subject | Help with FireBird SQL... |
---|---|
Author | Klerman Gutierrez |
Post date | 2003-08-05T18:38:18Z |
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
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