Would anyone be able to help me write a query activity in Marketing Cloud? I’m getting “multi-part identifier” errors and, when I try to put two tables in the FROM, I’m getting the error “Old style (ANSI JOINs) syntax not allowed.
What I’m trying to write for the query is: If settings.Number equals history.Number AND settings.ID is 1, then select all fields in the DE.
I thought I could do the below, but I was wrong.
SELECT * FROM settings, history WHERE setting.Number = history.Number AND settings.ID = 1