Trying to update a table with a (single) result from another table, I got an "Operation must use an updateable query" with this query:
update Service_case s
set s.owner_id = (select c.id from contact c where c.contact_name = "foo")
where s.device_sn = "bar"
Is the problem due to the potential...