I am trying to join 2 data extensions and input the result to a third data extension:
SELECT [Account ID] AS [Account ID], [Created Date Backend] AS [Created Date] FROM [DE A] A INNER JOIN [DE B] B WHERE A.[Account ID] = B.[Lead ID]
Currently getting a syntax error:
The query syntax is invalid
Incorrect syntax near the keyword 'WHERE'.
What am I doing wrong?