I need to query two data extensions to find any overlap between them. Our subscriber key for both DEs is Salesforce ID. Is there a simple query to use to compare these to see if any subscribers exist in both DEs?
SELECT a.field1, a.field2, b.field1 FROM TableA a INNER JOIN TableB b ON a.SubscriberKey = b.SubscriberKey
Give this query ago it’s a good starting point. Go and enjoy yourself
SELECT * FROM Table1 a JOIN Table2 b ON b.salesforceid = a.salesforceid