I am trying to return details associated with a certain email address . I am using the query below:
select emailaddress
,subscriberkey
,record_type_name__c
from
mastersubscriberde
where emailaddress ='xxx@email.com'
I am getting this error when i run it in Automation Studio:
Query failed during execution. Error: Conversion failed when converting the nvarchar value 'xxx@email.com' to data type int.
I will appreciate any pointers on this