Joining 2 columns from 2 different tables to replace null values in one of the tables
I have 2 tables with a column called Participant ID. One table is completely null/empty in said column and the other table is filled. I would like to input the data from the filled table into the empty table. Table 1 has 642 rows and Table 2 has over 6000.
Example of Table 1:
| ID | Last Name | First Name |
|---|---|---|
| null | Aba | Ase |
| null | Flo | Jas |
Example of Table 2:
| ID | Last Name | First Name |
|---|---|---|
| 53 | Aba | Ase |
| 54 | Flo | Jas |
How can I go about inputting the data from Table 2's ID column into Table 1's ID column to match with the names on Table 1?
I tried a RIGHT Join but it just gave me all of the data for all of the columns but I need to combine the ID columns.