JOIN (SQL)

A JOIN combines rows from two or more tables based on a related column, usually a foreign key matching a primary key.