I am sure this is a thing, but we have a group of "test" email accounts that our QA group regularly tests. Of course the unsubscribe is one of those things they test, and often we have to reset the status manually.
So I thought that I could make a daily automation to just update the specific records to "active" nightly so we never had to worry about it.
SELECT Email from 'Test_list' , compare against all subscriber and change the STATUS from "Unsubscribed" to "Active"
It SEEMS easy, but I am not sure how to do the query.