A join is the database process of comparing the data in specified columns and using the comparison results to form a new table or record set from the rows that qualify.
Specifically, a join statement:
Specifies a column from each table.
Compares the value in those columns row by row.
Combines data from rows with qualifying rows into a new table or record set.