Inner join selects rows that have matching values in both tables that are listed in the common columns in the ON clause. The values Maverick and Shawn were not in the Name column on both reports so those rows were omitted from the table.