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
Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. It only takes a minute to sign up.Sign up to join this community
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 FROM DEOne UNION ALL SELECT name, email FROM DETwo
The Target is DEThird.
Maybe you need to add aliases (but i dont think so)
SELECT one.name, one.email FROM DEOne as one UNION ALL SELECT two.name, two.email FROM DETwo as two
Target is DEThird.