<p>I have a right outer join, that almost does what I want...</p>

<pre><code>SELECT
users_usr.firstname_usr,
users_usr.lastname_usr,
credit_acc.given_credit_acc,
users_usr.created_usr,
users_usr.sitenum_usr,
users_usr.original_aff_usr,
users_usr.id_usr
FROM
credit_acc
right Outer Join users_usr ON credit_acc.uid_usr = users_usr.id_usr
</code></pre>

<p>The problem is, I want to add a </p>

<pre><code>where credit_acc.type_acc = 'init'
</code></pre>

<p>But this gets rid of all users who don't have a row in credit_acc... which is WHY I need a right outer join.</p>

<p>Is there a way to get this without having to do two queries and a union?</p>

```
```
SELECT
users_usr.firstname_usr,
users_usr.lastname_usr,
credit_acc.given_credit_acc,
users_usr.created_usr,
users_usr.sitenum_usr,
users_usr.original_aff_usr,
users_usr.id_usr
FROM
credit_acc
right Outer Join users_usr ON credit_acc.uid_usr = users_usr.id_usr
WHERE credit_acc.type_acc = 'init' OR credit_acc.type_acc is NULL
```
```
Or, as @Tomalak pointed out:
```
```
WHERE COALESCE(credit_acc.type_acc, 'init') = 'init'
```
```
which
may
be faster (see comments).