In Access, for example, there are two table t1, t2, the establishment of "generate table query" new table name tNew

SELECT t1. The field 1, t1. Field 2, t2. The field 1 INTO tNew
The FROM t1, t2
WHERE a t1. 1=t2. Field 1

To start some of the data in table tNew and table t1 and t2 data changes, I'd like to update the generated the data in table tNew,

Ask how to write the SQL sentence? Thank you very much!