I receive the following error message for my SQL statement and I cannot find the error: "An error occurred while checking the query syntax. Errors: Invalid column name 'Opt'
This was a quite similar problem, however it did not help me to solve my problem. Marketing Cloud SQL - Invalid Column Name
Does anyone has a solution for me. What did I do wrong? The SQL statement is:
I.PlayerID, M.Opt-In_Mail, S.Opt-in_SMS from ContactableUsers_MultiBetslip_20201110 as I inner join MasterData_Email as M on I.PlayerID = M.ID inner join MasterData_SMS as S on I.PlayerID = S.ID