Query to populate a field with different name in data extension

Question

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:

1. Name
2. State
3. Email Address
4. 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?

Answer 1

If you mean you want to fill in TEST A 'Subscriber Key' field with the info from 'TEST B' 'ID.account' field, then the following will do it for you:

SELECT Name
       , State
       , [Email Address]
       , [ID.account] as [Subscriber Key]
FROM [TEST B]

/* Target DE: TEST A */

Judging from comments - If you want to include ID.account in the query as well, just include , [ID.account] before the FROMand add the ID.account field to TEST A DE.