I have one table with many rows and columns. One of those columns is username. It is not unique. I have a second table of user details where the username is unique. I would like to add user details from the second table to first table. I can’t identify the correct way to do that. 'join’ing tables does not work.