This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

right outer join

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.