Attempting to query based on a data extension called [Users], but I want to extract ALL the contacts that are also in the [Unsubscribe] data extension.
I thought it would be a simple 'NOT IN' function, but do I need to INNER JOIN, as well?
SELECT * FROM ENT.[Users] WHERE Email Address NOT IN ENT.[Unsubscribe]