An SQL join is a query that combines data from two tables using one or more common columns to create a relationship between both tables.
The four main join types produce the following results (T1 is the first table and T2 the second):
INNER JOIN: Rows from T1 and T2 that satisfy the join condition […]