Should either be `left outer join` or this will need to handle null results.