I am trying to write an update query and I am having problems with
the firebird syntax.

The query involves 2 tables that are identical in structure but one
has updated data from another database


I want to match up the keys then update the data from the one table
to the second table

An example that works in a Access but not in firebird is as follows

UPDATE Contacts INNER JOIN Contacts1 ON Contacts.ContactID =
Contacts1.ContactID SET Contacts.FirstName = Contacts1.FirstName,
Contacts.LastName = Contacts1.LastName;


What would be the proper syntax for Firebird.

Thanks,

Fr. Robert