Eliminate Duplicates Rows

[farolito20]

I have two tables,

old_record

     id,name,age

new_record

     id,name,age

In some cases, the information in new_record is the same at the old_record, and I need to create one table with all the information from the two tables.

So, I use Autonumberhash(ID,NAME,AGE) to compare the information.

old_record:

load

          AutoNumberHash256(ID,Name,Age) AS key1

from DimCustomers_Day0.qvd (qvd);

new_record:

load

          AutoNumberHash256(ID,Name,Age) AS key2

from DimCustomers_Day1.qvd (qvd);

Then I wanna compare, but I don´t know how 😕