I currently have two tables, "tc\_services" and "tc\_users" which both have a "USER\_ID" field and "BILLING\_ID" field. I need to query these together, finding any results where...

A) "tc\_services" does not have a "BILLING\_ID"

B) "tc\_users" does not contain a "USER\_ID" that matches that of the coorelating "tc\_services"

I am trying to put together a JOIN query statement such as the following but not able to figure it out so far. Any help would be appreciated!

```
SELECT *
FROM tc_services AS services
JOIN tc_users AS users
WHERE services.USER_ID NOT IN users.USER_ID AND services.BILLING_ID = '';

```

[![Users](https://i.stack.imgur.com/uVRvn.png)](https://i.stack.imgur.com/uVRvn.png)

[![Services](https://i.stack.imgur.com/BW7VT.png)](https://i.stack.imgur.com/BW7VT.png)