Create a separate field/Table

[Anonymous]

Dear Team,

I want to create a new table/field by comparing fields in two different tables.

Example

Table I : User ID : Jebamalai.Pushparaj

Table II : User ID : Jebamalai.Dass

These two have same employee ID in both fields.

I want to generate a table/field where User IDs are different for the same employee IDs

Kindly guide me.

Regards

Jeba