I am newbie in SQL, but i have to populate one data extension (name = TEST A) from another data extension (name = TEST B).
The fields in 'TEST B' has name like: 1. Name 2. State 3. Email Address 4. Id.account
The fields in 'TEST A' has name like:
- Email Address
- Subscriber Key
I want to populate the DE 'TEST A' according the exactly name in common. And the records in 'ID.accout' (field in 'Test B') goes to field 'Subscriber Key' (in TEST A').
Someone could help me with this?