I have two tables.
ID NAME A01 John A02 Peter B01 Marta
Then I have a second table (note that this table purposely has more entries).
ID SURNAME A02 Smith B01 Clevens A03 Rogers A01 Brown
Both tables represent the same people with Names and Surnames, identified by ID. How I can join the data into one table and align the people correctly?
ID NAME SURNAME A01 John Brown A02 Peter Smith A03 Rogers B01 Marta Clevens