update error

[userZ]

access 2003, with this update query I get the error operation must use an updateable query

UPDATE table1A 
INNER JOIN Query1 ON table1A.f1 = Query1.f1 
SET table1A.f2 = Query1.f2;

If I save the Query1 records to a table, table2, then this works. why?.

UPDATE table1A 
INNER JOIN table2 ON table1A.f1 = table2.f1 
SET table1A.f2 = table2.f2;

How to fix it?.

 

[CJ_London]

because query1 has some features not appropriate to an update query - perhaps it is cartesian or a group by query. Simplistically, for an update query to work, all 'paths' must end in at an identifiable record. If you group by the there is no record to identify (which one in the group?). But save the results of a group by query as a table, and the path goes back to a record in that table