Getting error on the query and is below.
Email_Master primary key is 'Email Address' and thee target Data Extension primary key is also 'Email Address'. Can you help/advise what is the issue on the query statement?
ERROR: Query failed during execution. Error: Violation of PRIMARY KEY constraint. Cannot insert duplicate key in object 'In Email_Master _subscribers Status'
SELECT a.[Email Address] as 'Email Address', a.[Subscriber Key] as 'Subscriber Key', b.status as 'Engagement', b.SubscriberID, b.DateUndeliverable, b.DateUnsubscribed, b.DateJoined, b.BounceCount, b.SubscriberType, b.Locale, b.Domain FROM [Email_Master] as a JOIN [_Subscribers] as b ON a.[Email Address] = b.[EmailAddress]