How would I permanently update the data in a file in table a
with data from table b.

I have tried this and I get an error:

update a set testfieldname = b.fieldvalue from a, b
where a.fieldid = b.fieldid

Any help would be appreciated.