Join vs merge vs lookup

The obvious benefit of merge over join is the ability to add reject links.

I can't upload pictures. I will edit this later.