I am trying to check the data from particular data extension whether they exist in any other data extension. How can we compare a data from particular data extension with all other data extensions in ExactTarget? I tried something like this:
Select ls.SubscriberKey from _Subscribers ls INNER JOIN CTTrigger cs ON cs.EmailAddress = ls.EmailAddress
But no result. I have also tried using
_ListSubscribers but no result. Can anyone help me out in this? My data extension has email as primary key.