JOIN for data cleansing
JOIN for data validation
JOIN with composite keys
JOIN with natural keys
JOIN with foreign keys