User ID replacement

User ID replacement

Greetings.
Perhaps you can ask to provide an example of a query in the database to replace the user ID

I need to change the owner of all requests that were previously created by a user with id 102 to a user with id 120

So that a user with id 120 can see all the applications that were created by a user with id 102

I was able to write a query to display all user requests with id 102, but I can't figure out how to update.

My database knowledge is very poor.

                      New to ADSelfService Plus?