Joins

Left join provides a table which includes hits from the right table and the rest of the left table.

Inner join provides a table which only includes hits from the right table. It does not provide the rest of the left table.