I'm working on a database that has two tables that I'd like to combine into one. Here's the basic structure:
My goal is to just copy the name column from the UserNames table into the Users table, so that I end up with this:
I've already created the Name column within the Users table, but I'm unsure of how to write the SQL query to copy the names over from UserNames to Users. I want to do something like this: