Important conditions for joining two tables on a key?

Joining two tables