I have two tables ie table1 and table2.
The columns in table1 are:
unique_id1, forename, surname, address, dob, gender.
The columns in table1 are:
forename, surname, address, dob, gender, unique_id2
I want to take each record in table 1 match it to its corresponding record in table 2 and...