Inner join selects rows that have matching values in both tables that are listed in the common columns in the ON clause. The values 80204 and 10024 were not in the Postal Code column in both tables so those rows were omitted from the query result.