See left_join for more details.