make all SQL joins explicitly outer joins using the UNION syntax

[ClimbsRocks]

i had assumed that JOIN defaulted to LEFT JOIN. it defaults to inner join. explicitly using left join solved it.