I have a data extension that has email address along with some other data, but I need to get the persons first name and last name which exists in a different data extension.
What I need to do in the automation query is to take all email addresses from DE1 and match it up against the email address from DE2. From there, pull the FirstName and LastName values from DE2 and write the results to DE3 which will accept EmailAddress, FirstName, and LastName.
I'm looking at JOIN, INNER JOIN, UNION, OUTER JOIN... I have no idea which is the correct one to use or how that syntax should really look.
I assume it would be something like this overly simplified example:
SELECT EmailAddress, FirstName, LastName FROM DE2 JOIN EmailAddress FROM DE1