Example is to self join a list of employees against itself to see what employees share common data points (such as managers, depts, etc.). I have used this technique for de-duplicating existing data sets for analysis and forensics projects.