Question: My SQL is a little rusty, but this query should be simple enough. I'm trying to get a list of all the emails in the all subscriber list that have a status of "unsubscribed" or "held" in the system. The following query errors on "\_Subscribers is not a known data extension or system data view." I'm sure I don't have the table name correct, but I'm not sure what it is or how to find it.

```
SELECT EmailAddress, SubscriberKey, [Status]
FROM _Subscribers
WHERE [status] is ('unsubscribed','held')

```

Answer: 
If you're getting that error, I assume you are trying to access the \_Subscribers Data View from a child Business Unit. Try the following (and note the `IN` operator):

```sql
SELECT EmailAddress, SubscriberKey, Status
FROM ENT.[_Subscribers]
WHERE [Status] IN ('unsubscribed','held')

```
You can try this also.

```sql
select j.JobID ,u.EventDate, s.EmailAddress, s.SubscriberKey
From _job j Join _Unsubscribe u on j.JobID = u.JobID
Join _Subscribers s on u.SubscriberID = s.SubscriberID
Where u.IsUnique = 1 And u.Eventdate > dateadd (d,-30,getdate())

```