Hi sir,
I'm a Delphi expert, workink with it connected to several DBMS like InterBase and MSSQL for 16 years now. I'm able to perform this update for you in several ways. For the best performance, if you don't need to update the tables data, I advise to use a joined query between the 2 tables.
Best regards,
Fred