INNER JOIN
An INNER JOIN returns only the rows that have a match in both tables. Rows with no matching partner in the other table are left out of the result.
An INNER JOIN returns only the rows that have a match in both tables. Rows with no matching partner in the other table are left out of the result.