Loading 2 tables fields distinct values in to new table

[Lalithac]

I want to load the common fields distinct values in to a new table and again I want to use those in 2 tables without any synthetic key generation.

[Taoufiq_Zarra]

@Lalithac  you can use keep join or can you share a sample data and the expected output ?