Two columns in the table is the same, the primary key part of the same value, how to find out all of the primary key of the same line of the data are the same
For example, table 1 ID NAME AGE SEX
Table 2 ID1 name2 age2 sex2

Two part ID in the table is the same, how to find out the similarities and differences between other values of different ID and the same ID