Trying to update a table with a (single) result from another table, I got an "Operation must use an updateable query" with this query:
Is the problem due to the potential of the sub-query's returning more than one result (although that's not the case here)? I know that if I replaced the sub-query with, say, 4, then it would work.
Code:
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 of the sub-query's returning more than one result (although that's not the case here)? I know that if I replaced the sub-query with, say, 4, then it would work.