This is the key point:
" regardless if there is an address for each of those people: "
if you useINNER JOIN,the result will exclude those people who don't have an address in the data.
It's like intersection in mathematics---"A∩B"
Combine Two Tables