Hey guys, so I have two tables. They are pictured below.
I have a master table "all_reports". And a user table "user list". The master table may have users that do not exist in the user list. I need to add them to the user list.
The master table may have duplicates in them (check picture). The master list does not contain all the information that the user list requires (no manager, no HR status, no department.. again check picture).
so in summary, distinct users from master table that do not exist in user table need to be migrated over. Only fields that are common to them is recipient ID, and recipient name