Hi i am trying to achieve

SELECT name, email(primary key) FROM DeOne, DeTwo Update DeThird

Fields are same in all 3

Can Someone correct me


You can achieve this by using UNIONS. Unions are a way to combine data of two or more dataextensions and insert the result into the dataextension (or table) of your choice.

Here are some nice posts regarding unions:

Depending on your use case you need to switch between union and union all. Union will perform in a way that you will only get distinct rows while union all will not. Because you have a primary key in your dataextension you might get into conflicts when you have an email adress in both source target dataextensions. Just wanted to inform you, that you are aware of it.

The Query would be:

SELECT name, email
SELECT name, email

The Target is DEThird.

Maybe you need to add aliases (but i dont think so)

SELECT one.name, one.email
FROM DEOne as one
SELECT two.name, two.email
FROM DETwo as two

Target is DEThird.

  • Thanks Johannes – James Jul 25 '19 at 10:25

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.