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 ='firstname.lastname@example.org'
I am getting this error when i run it in Automation Studio:
Query failed during execution. Error: Conversion failed when converting the nvarchar value 'email@example.com' to data type int.
I will appreciate any pointers on this