I am trying to run a sql query in Automation studio MC for syncing my Sync DE( Contact_salesforce) to a local DE. I want to send email to tht=at local DE in the next automation. But I am facing issue in running this query as it doesnt create records in the local DE. in Local DE ( name of local DE = Another1) I have selected Contactkey as a primary key. and my query runs like this
, s._Contactkey as [Subscriber Key]
, s.AccountId, Contactkey
FROM Contact_Salesforce s
INNER JOIN Another1 m on (s._Contactkey = m.Contactkey)
My data action 'update' as I will be running this query whenever vales change in Sync DE Contact_Salesforce. I am not getting any validations as all fields are mentioned. But when I run it no records gets populated in the Local DE. What am I missing?