Please excuse my ignorance, as this seems like a simple thing. I'm just new to to SQL and am having trouble working it out.
I have a data extension of records with a blank Variable field. I have a second data extension with a shared key with the first data extension. I want to write a SQL activity to use in an automation to update the variable field in DE 1 to a specific value ("Match") where they match on the key in DE 2. I've tried to look it up, but most of my googling leads me to INSERT, which i don't think is possible in SFMC.
Thanks in advance for the help.