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:

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.


You can certainly find matching subscribers in Data Extensions or in the System Data Views with SQL JOINS.

If you have an Enterprise 2.0 account, All Subscribers is shared by all business units (at the parent level) and therefore needs an ent. prefix (if you're in a child business unit)...as do all shared Data Extensions.

from ent._Subscribers s  
INNER JOIN CTTrigger t ON t.EmailAddress = s.EmailAddress

There's no way to check "all other data extensions". You'll have to name them explicitly.

  • Hi Adam i tried a simple query with _subscribers like "Select TOP 5 a.Subscriberkey from _subscribers s " but it doesn't work.I think my account is not an Enterprise 2.0.Where can i check the version number? – Manoj Chandran Mar 30 '16 at 11:50
  • try select top 5 s.subscriberkey from ent._subscribers s – Adam Spriggs Mar 30 '16 at 11:53
  • Hi Adam its working ,so this will query only the subscribers from parent account or will return users from both parent and child?sorry for being burden I am new to Exact target – Manoj Chandran Mar 30 '16 at 12:01
  • Both parent and child. Subscribers in a 2.0 (which you have) are shared across all business units. – Adam Spriggs Mar 30 '16 at 12:03
  • What if i want them to check only in parent account is there any way?like we are quering Data extension in parent account like ent.[DE] – Manoj Chandran Mar 30 '16 at 12:08

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.