Need help with updating records based on a query with multiple tables

[TGM1]

I apologize but, I am an absolute newbie when it comes to databases and SQL. I am working on a database for my radio club (I am the only one that was willing to give it a try) and I am having a problem with updating a table field after a query. I am using LO Version: 6.2.0.3 (x64) on Windows 10.

I am wanting to locate the records in tbl_Old that are not in tbl_New and flag the records for manual updating.

This is a sample of the tables that I am using:

Running (in Tools>SQL): SELECT “Record” FROM “tbl_Old” WHERE “Record” NOT IN ( SELECT “Record” FROM “tbl_New” )

Returns the expected

This is where I am hitting the snag, and have not been able to find a solution. I want tbl_Old to be updated to this:

I have searched and searched and have been unable to find anything that will work. I am able to update ALL of the tbl_Old.Flag with UPDATE “tbl_Old” SET “Flag” = ‘D’ but I want to only update the selected records. Any ideas on how to do this?

[Rolandvl]

execute following sql:

UPDATE “tbl_Old” SET “Flag” = ‘D’ WHERE “tbl_Old”.“Record” NOT IN (SELECT “Record” FROM “tbl_New”)

[TGM1]

I could have SWORN that I had tried that SQL and it did not work but, I must have been wrong, worked perfect. Thank you very much.