A means for combining fields from two tables by using values common to each. It’s possible to combine fields by utilizing different kinds of joins, such as: – inner join: Returns all rows from multiple tables where the join condition is met. – left join: Returns all rows from the left table, and the matched rows from the right table. – right join: Returns all rows from the right table, and the matched rows from the left table. – full join: Return all rows when there is a match in ONE of the tables.