I've just created two synchronized data extensions in Contact Builder and then discovered that both data extension have fields the other does not have. The first synced DE is Account_Salesforce and the second is Contact_Salesforce.
The first DE has account level information and the second has contact level information.
I would like to combine the industry info from the account level and merge that info with the contact level info in a new DE.
I'm a beginner with SQL, but here is what I tried in the parent level Query Studio.
JOIN [Contact_Salesforce] s
ON sm.ID = s.ID
Any help will be greatly appreciated.