An outer join in which all the records from the right side of the RIGHT JOIN operation in the query's SQL statement are added to the query's results, even if there are no matching values in the joined field from the table on the left. Records from the table on the left are combined with those from the table on the right only when there are matching values in the joined fields.
A right outer join is indicated by a join line arrow (Microsoft Access database) or key symbol (Microsoft Access project) pointing from right to left.