I think I got it. I used this as part of the query still using a full outer join:

coalesce(a. ) as columnName

Thanks again!

This works great one way...

If in table a, we have instances where player b did not play, we get the correct response. Now we need to add instances where there...