I apologize if this is a duplicate, however, I cannot find the answer I need.

Consider my data:

**Table - report\_detail**

```
report_id   |category    |sub_category   |report name
-------------------------------------------------------
1           |1           |1              |Donkey Report
2           |2           |2              |Grandma Report
3           |1           |1              |Poop Report

```

**Table - report\_subscriptions**

```
user_id     |report_id
--------------------------
1           |1            
2           |2            
1           |2

```

My question is, how do I select all of the report\_id's from the report\_detail table that are not subscribed to user\_id = 1 in report\_subscriptions?

Thank you!