Specifying join keys and their matching conditions

Without specifying a join key: the ‘natural join’ is applied (messages in previous slides).

BUT:

• this will miss key pairs with different names
• this will assume any pair of identical variable names to be part of the key pair