Unanswered: "operation must use an updatable query"
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.