Records from a (INNER) JOIN are those with matching values in both tables.

RIGHT (OUTER) JOIN: Returns the matched records from the right table along with all of the records from the left table.
RIGHT (OUTER) JOIN: Returns all data from the right table together with the data from the left table that matches.