check if column number in 'table1' equal to column number in 'table2', then if equal insert the row from 'table1' to 'table2'

Table1 Table2 for my question: if id1 numbers in Table1 equal to id2 numbers in Table2, then add to Table2 the content of the row (fname_c1,fname_c2,lname_c1,lname_c2,by,bm,bd) from the Table1 that matches.

for example: (if id=55 in Table1 and id2=55 in Table2 (which is id1=id2=55), then add to Table2 the columns (fname_c1,fname_c2,lname_c1,lname_c2,by,bm,bd) with their rows that matches from Table1 and so on.

(my data is a big dataset so I can't add by typing for example c("FRANK") for each match so that why I want to transfer the content of table1 to table2 by matching them by ids ).

here is an example of Final result how will look like: Table2 after adding the matches from Table1