Join (SQL)
Suppose a database administrator wanted to know what employee worked in what department.  While someone could just compare the ID numbers between the two tables, a way to have the information in one place is by doing a JOIN, also known as an INNER JOIN.  Because they have one type of data in common, the department ID, the tables can be joined together.