sql - How to update based on subquery?

Question

I have two tables:

Product
Id
Code
Value

question from:https://stackoverflow.com/questions/65916068/how-to-update-based-on-subquery

Answer 1

Your subquery returns multiple results (as the error says). You can limit the updated rows by using, for example, an aggregate function as follows:

update Product P set P.Code = (select MAX(Serial) from Info where id = P.Code);