Im trying to update a table with records from a query with a lots of joins and subquerys.
I understand that the query does not work to update underlaying tables, but shoulden't i be able to update the table (t1) with a simple select from that UnUpdatableQuery?

update t1, UnUpdatableQuery
SET t1.r1 = UnUpdatableQuery.r1
where t1.ID = UnUpdatableQuery.ID

ID in both tables are PK an i have tried to join them in the update query without success. Same error ("operation must use an updatable query") no matter what i try.

Thx in advance for any help and hints.