I am new to SQL and I would like to know how can I insert/update rows in a specific column (e.g only email address) to another data extension via query.
What I am trying to do is to update any new email addresses from a filtered data extension to the All Subscribers List. Hence the columns that I am interested in are: "Email_Address__c" from "FilteredDE" as well as "SubscriberKey" and "EmailAddress" from "_subscribers".
I looked up on sql forums and most of them suggested using INSERT INTO. However when I tried using it, Salesforce Marketing Cloud doesn't allow INSERT INTO to be used.
Can anyone give me any advice on this?