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.
Select sm.ID , sm.Sub_Industry__c , sm.InsideView_Industry__c , sm.Industry , s.ID , s.AccountID , s.Email FROM [Account_Salesforce] JOIN [Contact_Salesforce] s ON sm.ID = s.ID
Any help will be greatly appreciated.