New to SQL so be nice! :)
I'm trying to run a simple SQL query in Automation studio, unfortunately I am getting this error - "An error occurred while checking the query syntax. Errors: Incorrect syntax near the keyword 'Key'."
select Account_ID, First_Name, Gender, Communication Key, Email_Address, SubscriberKey from [TEST_De] where Subscriberkey not in (select Subscriberkey from _sent where JobID = XXXXXX)
Now, straight away the empty character in
Communication Key stands out as the culprit. However please note that this is exactly how the field is presented in the DE.