UNION SELECT voegt het resultaat van twee tabellen samen.
SELECT EmailAddress, SubscriberKey FROM [tabel 1] UNION SELECT EmailAddress, SubscriberKey FROM [tabel 2]