SQL to set Display Name to First Name + Last Name

Figured out the SQL query that can be used to reset the display_name to first_name + last_name. And it’s simpler than the JOINs that I was trying when I posted the question.

UPDATE wp_users 
SET display_name = Concat(
    (SELECT meta_value 
     FROM   wp_usermeta 
     WHERE  meta_key = 'first_name' 
     AND user_id = id
    ),
    ' ',
    (SELECT meta_value 
     FROM wp_usermeta 
     WHERE 
     meta_key = 'last_name' 
     AND user_id = id
    )
);